SSIS : how to store password of connections

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

laurenceAtosOrigin - 27 Nov 2007 09:42 GMT

I made a package that copies data from one table of a sql server database to
another table of another database sql server.
I use oledb connection for the two connection
I want to store user and password of the two connection to avoid retype them
every time I launch package .
I don't find any solution.
I try to use configuration file but even with this, I must add password in
the Execute Package UTility in the connection manager.

I try different package protection level but i can't store password.

Is it possible to store password and in this case how must I do ?
Thanks for your help

Reply to this Message

Ben Nevarez - 27 Nov 2007 10:06 GMT

See 'Setting the Protection Level of Packages' on BOL and see if any of the
protection levels, specially EncryptAllWithUserKey and
EncryptSensitiveWithUserKey may fit your needs.

Hope this helps,

Ben Nevarez
Senior Database Administrator
AIG SunAmerica

> I made a package that copies data from one table of a sql server database to
> another table of another database sql server.
[quoted text clipped - 9 lines]
> Is it possible to store password and in this case how must I do ?
> Thanks for your help

Reply to this Message

laurenceAtosOrigin - 27 Nov 2007 10:33 GMT

Thanks , but I already try the different type of protection level.

In the connection manager windows, when you check "Save my password" , it is
not saved. How can i use this checkbox. what else must i DO?
Thanks

> See 'Setting the Protection Level of Packages' on BOL and see if any of the
> protection levels, specially EncryptAllWithUserKey and
[quoted text clipped - 19 lines]
> > Is it possible to store password and in this case how must I do ?
> > Thanks for your help

Reply to this Message

edrenawilliams - 27 Nov 2007 16:12 GMT

I just recently purchased a computer from a friend i am trying to set a
password so i am the only one that is able to sign on to the computer. I have
set a password for my user name but you can type in any name into the user
box at start up and it will start to make a profile for that name and log
them on to the computer. I want to set it where i am the only one that can
log on because if it gets stolen anyone can just log in and start working on
it. Thanks Please if you can email the response to
edrenawilliams@sbcglobal.net because i don't really know how to use this
website.Thanks

Reply to this Message