SMO Connection Manager in SSIS
The SMO (SQL Server Management Objects) Connection Manager establishes a connection with the SQL Management Object server. In Integration Services, all the Database related tasks use SMO Connection Manager to connect with SQL server objects. For example, the Transfer SQL Server Objects Task uses SMO Connection Manager to connect with the server. Configuring SMO Connection Manager in SSIS … Read more
