package configurations

Hi,

i keep struggling with dtsconfig.

i have 4 packages which all have the same datasource based on the global-datasource.

is there a way i can save that global-datasource, instead of configuring all 4 packages to use a config-file?

Mafti,

What is your issue?

Setting package configuration should be a 1 time setting during development; then you have to change the config file only when a change in the connection string occurs (server name, credentials, etc).

The other way would be to save the connection credentials (some sensitive data involved) within the package definition; but for that SSIS requires the sensitive data to be encrypted; creating other potential deployment issues. If you want to follow that path; look in BOL or this forum for a property at the package level called ProtectionLevel

|||

I think I have the same question.

I want to set my connection strings from a config file.

Is there some way to configure the Global Datasource to use an expression to set the connection string? It seems the only way to set it from a config file is to add a connection to the connection managers from the Global Datasource, then set the expression for the connection in the package itself. Thereby making the use of the Global Datasource useless in this instance, other than not having to retype the name.

|||Make it simple:

We have 1 global .dtsConfig file which stores db connection string (all packages have variable DB_CONN_STR) - and each DB provider you use - use expression to set the connstring

Also - for every package we have separate config file to set specific info like FTP user/pass etc.|||

that is what i am doing.

the problem is that there is no way to set up a global datasource to use a variable, or so it appears.

That forces you to either:

1) create a new connection each time and configure it to set the connection string from a variable (expression)

2) use a global datasource then modify the actual connection created from it to set the connection string from a variable (expression).

|||

Karstman wrote:

that is what i am doing.

the problem is that there is no way to set up a global datasource to use a variable, or so it appears.

That forces you to either:

1) create a new connection each time and configure it to set the connection string from a variable (expression)

2) use a global datasource then modify the actual connection created from it to set the connection string from a variable (expression).

No matter if you use a 'global data source'; the data source information is copied on each package that uses it. Thos solution for me is not to use those data sources at the project level as I don't see any added value on using them.