December 5, 2008 at 2:54 pm
Hi,
I have developed SSIS packages at Testdevelopment environment. I am using configuration files, which are stored in all machines at the same location, with two folders, SSIS_confugurationFiles and SSIS_Dependencies.
When, I deploy from TestDevelopment environment to other server(UAT), in the deployment wizard I changes the value of configurations files, like server name, username and password etc and are stored in SSIS dependencies of TestDevelopment machine. But these values are same as UAT machine, SSIS_ConfigurationFiles values.
According to me, when I deploy from TestDevelopment to UAT, and run the package (Actually our packages are called by Filewatcher service), it should pickup those configuration values from UAT machine, SSIS_Dependencies folder right ? In our case, it is still getting executed in TestDevelopment machine ? I also, copied configuration files from one machie to other.
It worked, when I imported the package from UAT machine, msdb to local folder and re-deployed to that server(UAT) ? So, what is the whole point of configuration files then ?
Ideally, Have same path location for all configuration files folder on all machines. Then develop SSIS package in one machine and when deploying, change the values in Configure Packages step in the wizard and complete the wizard. Copy the configuration files to all machines if necessary or changed. Thats it right ? IS htere any cashe problems ? or Do i have to stop and re-start integrationservices service once ?
Thanks for your inputs..
-VG
December 8, 2008 at 4:26 am
I think the best thing way to set up configuration is to set a primary package configuration to point to your local SQL server.
then subsequently set up your connections in an SQL configuration table.
That way on each server you can append the various connection strings / values from within the SQL server table.
_____________________________________________________________________________MCITP: Business Intelligence Developer (2005)
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply