| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | f1_keywords | helpviewer_keywords | ||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SMO Connection Manager |
SMO Connection Manager |
chugugrace |
chugu |
03/14/2017 |
sql |
integration-services |
conceptual |
|
|
[!INCLUDEsqlserver-ssis]
An SMO connection manager enables a package to connect to a SQL Management Object (SMO) server. The transfer tasks that [!INCLUDEssNoVersion] [!INCLUDEssISnoversion] includes use an SMO connection manager. For example, the Transfer Logins task that transfers [!INCLUDEssNoVersion] logins uses an SMO connection manager.
When you add an SMO connection manager to a package, [!INCLUDEssISnoversion] creates a connection manager that will resolve to an SMO connection at run time, sets the connection manager properties, and adds the connection manager to the Connections collection on the package. The ConnectionManagerType property of the connection manager is set to SMOServer.
You can configure an SMO connection manager in the following ways:
-
Specify the name of a server on which [!INCLUDEssNoVersion] is installed.
-
Select the authentication mode for connecting to the server.
You can set properties through [!INCLUDEssIS] Designer or programmatically.
For more information about the properties that you can set in [!INCLUDEssIS] Designer, see SMO Connection Manager Editor.
For information about configuring a connection manager programmatically, see xref:Microsoft.SqlServer.Dts.Runtime.ConnectionManager and Adding Connections Programmatically.
Use the SMO Connection Manager Editor to configure a [!INCLUDEssNoVersion] connection for use by the various tasks that transfer [!INCLUDEssNoVersion] objects.
To learn more about the SMO connection manager, see SMO Connection Manager.
Server name
Type the name of the [!INCLUDEssNoVersion] instance or select the server name from the list.
Refresh
Refresh the list of available [!INCLUDEssNoVersion] instances that can be detected on the network.
Use Windows Authentication
Use Windows Authentication to connect to the selected [!INCLUDEssNoVersion] instance.
Use SQL Server Authentication
Use [!INCLUDEssNoVersion] Authentication to connect to the selected [!INCLUDEssNoVersion] instance.
User name
If you have selected [!INCLUDEssNoVersion] authentication, enter the [!INCLUDEssNoVersion] user name.
Password
If you have selected [!INCLUDEssNoVersion] authentication, enter the password.
Test Connection
Test the connection as configured.