sql server dts: Decrypt Configuration file in SSIS Package -- sql server dts

Decrypt Configuration file in SSIS Package

yesha javia
2/27/2007 12:18:30 AM

sql server dts:

Hi,

i would like to encrypt password in my configuration file as well as i
would like to decrypt my password before executiong SSIS Package.

i am unable to do the same. if anyone can help me.
please reply

Re: Decrypt Configuration file in SSIS Package

Allan Mitchell
3/2/2007 4:47:42 AM

The configuration file is applied before execution of the package so
nothing inside the package could decrypt it.

Perhaps you could have a package which called a decrypter and then call
the other package through an Execute Package task and then call an
encrypter after that.

--

Allan Mitchell
http://wiki.sqlis.com | http://www.sqlis.com | http://www.sqldts.com |
http://www.konesans.com

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server dts group.