Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Error: The package is encrypted with a password. The password was not specified, or it is not correct. Expand / Collapse
Author
Message
Posted Wednesday, December 19, 2012 8:40 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 8:03 AM
Points: 4,052, Visits: 4,192
I get the following error with one of my packages:

Error: The package is encrypted with a password. The password was not specified, or it is not correct.


The package connects to an AS400 so it is necessary to save sensitive with user password.

If I select save sensitive with user password, build a deployment and run the manifest it does not prompt me for the password.


If I select Save all with user password I get the error listed below.

What is strange is I have another package that is almost identical to the one that I'm having trouble with (pulls from different library) and I don't have any issues with it.

Any help would be greatly appreciated.


For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Post #1398461
Posted Wednesday, December 19, 2012 10:12 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, April 14, 2014 2:16 PM
Points: 2,812, Visits: 2,543
I use "Don't save sensitive" and Package configurations for user names and passwords. Works like a charm.
Post #1398530
Posted Wednesday, December 19, 2012 10:51 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 8:03 AM
Points: 4,052, Visits: 4,192
Daniel Bowlin (12/19/2012)
I use "Don't save sensitive" and Package configurations for user names and passwords. Works like a charm.


I take it that you do not use DB2 or Oracle in your packages?

I must specify a package password on the DB2 Connection or I get an error.

There are other reason that you may want or need to encypt as oppsed to Don't Save Sensitve.


For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Post #1398558
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse