May 2, 2012 at 5:16 am
I create two Package Configuration Files and each is used by 4 Packages.
If you open up the dtsconfig and view it is XML I see the UserName and Password Properties but I do not see the values.
How do I change the password in the dtsconfig, how would I do this?
Something else that I don't understand is that you define that package configuration file in BIDS but you do this again in the Job on the configuration tab. Why is that?
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 2, 2012 at 8:55 am
You can simply edit the config file and add the values or tweak the connection string in about any way you want.
Depending on how you setup package configurations depends on whether the job has to be configured for them. If you set them up at design time you set the location and name of the files, this location has to be duplicated on the server. If you touch all the packages to use the same files I would offer this suggestion though, set the read-only attribute to the file. Because when you try to add it on each package it will over-write the file. When its set read-only it just complains and then uses it.
I believe that you can use the config files at run-time without first setting them up packages. But you will likely use a package to build the files. I would recommend an all or none approach.
If the package is expecting a configuration file at a specific location(as set at design-time) it will issue a warning but will NOT FAIL. It sounds like you are setting them at both run-tim and design-time.
CEWII
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply