Lost with Password

[MIB]

In my package, i'm using an DSN connection with a password to DB2. When the
package is running on my PC, every thing is working very well. But when i
trying to run the package on the server, i have a connection problem. The
only solution i found was to open the solution on the server, a giving again
the password, testing it and saving the solution.
What is the problem? how does it work ?
What is the solution?

[Todd C]

Check out these two blogs:

http://toddchitt.wordpress.com/2008/06/30/ssis_pw/

and if you want to go with a Configuration database, which would allow you
to save passwords and connection string OUTSIDE of SSIS:

http://toddchitt.wordpress.com/2008/06/27/ssis_config/

Keep us posted.
--
Todd C

[If this response was helpful, please indicate by clicking the appropriate
answer at the bottom]

Post by MIB
In my package, i'm using an DSN connection with a password to DB2. When the
package is running on my PC, every thing is working very well. But when i
trying to run the package on the server, i have a connection problem. The
only solution i found was to open the solution on the server, a giving again
the password, testing it and saving the solution.
What is the problem? how does it work ?
What is the solution?