Lost with Password

#1

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?

#2

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]

"MIB" wrote:

Quote:

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?

#3

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]

"MIB" wrote:

Quote:

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?

#4

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]

"MIB" wrote:

Quote:

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?

#5

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]

"MIB" wrote:

Quote:

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?

#6

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]

"MIB" wrote:

Quote:

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?

#7

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]

"MIB" wrote:

Quote:

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?

#8

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]

"MIB" wrote:

Quote:

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?

#9

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]

"MIB" wrote:

Quote:

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?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Lost with Password

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Lost with Password - 10-21-2008 , 05:10 AM

RE: Lost with Password - 10-21-2008 , 07:53 AM

RE: Lost with Password - 10-21-2008 , 07:53 AM

RE: Lost with Password - 10-21-2008 , 07:53 AM

RE: Lost with Password - 10-21-2008 , 07:53 AM

RE: Lost with Password - 10-21-2008 , 07:53 AM

RE: Lost with Password - 10-21-2008 , 07:53 AM

RE: Lost with Password - 10-21-2008 , 07:53 AM

RE: Lost with Password - 10-21-2008 , 07:53 AM