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

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Data Warehousing » Integration Services » Error: The package is encrypted with a...

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

Rate Topic

Display Mode

Topic Options

Author

Message

Welsh Corgi

Posted Wednesday, December 19, 2012 8:40 AM

Hall of Fame

Group: General Forum Members
Last Login: Wednesday, May 22, 2013 6:19 AM
Points: 3,833, Visits: 4,052

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

Daniel Bowlin

Posted Wednesday, December 19, 2012 10:12 AM

SSCrazy

Group: General Forum Members
Last Login: Wednesday, May 22, 2013 1:10 PM
Points: 2,673, Visits: 2,418

I use "Don't save sensitive" and Package configurations for user names and passwords. Works like a charm.

Post #1398530

Welsh Corgi

Posted Wednesday, December 19, 2012 10:51 AM

Hall of Fame

Group: General Forum Members
Last Login: Wednesday, May 22, 2013 6:19 AM
Points: 3,833, Visits: 4,052

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 »

Permissions