Package Configuration...
-
Hi,
I am trying to create an xml configuration file to dynamically define the connection string of the source and target tables at runtime. This is to ensure minimal changes during package movement from dev to production environments. Am not really sure hw to do this. Any help wud be appreciated.
TIA
-
ok...i have figured out hw to create the .dtsconfig file but nw when i execute the package using the DTExecUI.exe and specify the configuration file name, it doesnt really change the target connection string according to the connection i hav specified in the .dtsconfig file. it still uses the same target connection that i have specified in the data flow task!
-
Sunil:
I am still finding my way around Integration Services, but I think this will help...The config file can be changed manually, or if you create a deployment utility when you deploy the package to a new environment it will prompt you for the variables you want to populate.
If you need more info please let me know...
Erich
-
I have tried that. When i deploy the package and specify the config file to be used in the new environment, it doesnt change the target connection string. Its like this... i have specified a flat file connection 'abc' using the connection manager during package development. Now i wanna run the package using a connection 'xyz' which i have specified in a config file. When i execute the package using DTExecUI.exe it still connects to the target using the 'abc' connection.
-
If you look at your connections in the Package designer do they show up as variables?
-
Yes... They do
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply