Tuesday, March 20, 2012

Connection manager or Data Source

For seting up the connection should we use Connection Manager or New Connection From Data Source?

The advantage of using Data Source is that we have the connection avalilable at project level but I've studied it somewhere that Data Source is used for SSAS not SSIS.

But I don't have enough explanation to give it to my team, that why I am not using Data Source.

We are working on VSS, do we have to reset the connection managers if want to test our packages on some other machine(else than the one on which it was developed)?

I would use connection managers. (Actually, I DO use connection managers). Using package configurations, you can make the connections "dynamic" so-to-speak.|||

Paarul wrote:

For seting up the connection should we use Connection Manager or New Connection From Data Source?

The advantage of using Data Source is that we have the connection avalilable at project level but I've studied it somewhere that Data Source is used for SSAS not SSIS.

But I don't have enough explanation to give it to my team, that why I am not using Data Source.

We are working on VSS, do we have to reset the connection managers if want to test our packages on some other machine(else than the one on which it was developed)?

Both SSIS and SSAS can use data sources; but in SSIS they are optional. On my first SSIS projects I started using data sources until I realized SSIS checks the connection manager properties against the DS definition and gives annoying warnings about they being out of sync (usually the order of the parameters in the connection string)...and that happened every time you open a package. So, now I am creating the connection managers without using DS.

sqlsql

No comments:

Post a Comment