Home » BI Tools » Integration Services » Shared Datasource and Connection Managers

Shared Datasource and Connection Managers

The Shared Datasource is the Datasource which can be used by more than one package which has the connection String and credentials stored for a DataSource.

Example: You can make a Datasource named TestDB for Shared DataSource which connects to TestDB with Windows Authentication on Server named “TestServer”.

Various Connection managers are available to SSIS package like SQL Server Connection manager, OLE DB Connection manager, Flat File Connection manager, Share DataSource Connection manager etc.

Leave a Reply

Your email address will not be published. Required fields are marked *