Connections

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Arne Garvander - 25 Jul 2008 18:34 GMT

Why does SSIS have both a connection manager and data sources?
Do you have a good learning source to recommend?

Signature

Arne Garvander
(I program VB.Net for fun and C# to get paid.)

Reply to this Message

Todd C - 28 Jul 2008 14:33 GMT

Arne:

I know, it's a bit of a mis-nomer. Data Sources are set up at the Project
level, then, within each package, you can create a Connection Manager from a
Data Source. But the CM from a Data *SOURCE* will half the time be a
*DESTINATION* in the package.

I think this may have something to do with it: If you design 10 packages and
all of them use the same connection from the Project's Data Sources, then if
you go and change a Data Source at the project level, it should change it for
every CM that you created from it. Sort of centralizes the management of the
Data Sources.

HTH

Signature

Todd C

> Why does SSIS have both a connection manager and data sources?
> Do you have a good learning source to recommend?

Reply to this Message

Joe H - 31 Jul 2008 16:14 GMT

Also when you start using package configurations - you simply adjust the
Data Sources connection properties instead of all the "Connection Managers'
collections.

> Arne:
>
[quoted text clipped - 18 lines]
>> Why does SSIS have both a connection manager and data sources?
>> Do you have a good learning source to recommend?

Reply to this Message