November 20, 2008 at 6:49 am
Hi,
I have a SSIS package in which I have several source file and distination database connection, I have to send package for production server where I need to change the connection properties.
How can I make them global/dynamic so that on production server it can be changed according to the production server settings.
Please help
vaseem
November 20, 2008 at 8:52 am
This is handled in SSIS through "Package Configurations". They can be configured through the SSIS menu in BIDS. Look them up in Books Online and post again if you have any specific trouble.
November 20, 2008 at 9:35 am
Hi
I have create a package configuration using package type "XML configuration" and exported the all connection ( database/flat file location/ftp location) and its created myfile.dtsConfig properly.
After this I have saved the packeg at one folder naming mypackage.dtsx along with config file
When I double clicked the the dtsx package its asking to load the configuration file, I browse and load the file but it did not executed that due to connection error.
When I open the configuration file, I found that the connection which I have stored in configuration file are available in xml format but there is no password value. There is password tag but no value, I think password are not exported.
When I again open the application in VS then its giving error in loading the config file.
Pleae suggest me how to use this.
Vaseem
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply