July 21, 2006 at 2:48 pm
Guys can someone tell me how to use this file.
My package was running fine in dev. In prod i have to store passwords in the config file.
I created a package config file.
In the config file i just selected the connection manager checkbox.
All the fields are dimmed and i cannot type in anything.
It does not seem to store any passwords because i'm getting errors login errors in the package.
Where in config file should i type in the passwords and how should i use that encrypt sensitive data with key?
Thanks for all your help.
July 24, 2006 at 8:00 am
This was removed by the editor as SPAM
July 28, 2006 at 1:44 pm
if you want to execute the package via the agent you have first change the protection level to DontSaveSensitive or EncryptWithPassword (This is in the package properties). The default is EncrypWithUserKey which is only good for executing from the designer. After you save the package like this it will no longer contain any database passwords. Then, when you create the config file, you have to edit the config wilh notepad and enter the passwords in the appropriate place in the XML. You can also open the config with xcel which will provide a much better look at at the contents, but can't be used to save the file.
August 1, 2006 at 11:05 am
Finally an answer i was waiting for.
THANKS BRO
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply