Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Tasta
Yak Posting Veteran
60 Posts |
 Posted - 2009-02-17 : 05:01:41
|
| Hi, I'm trying to run the package that contains Execute package task. It runs OK in cmd , but as a job in SQL Server Agent, it gates stuck with the following error message :Error: 2009-02-17 10:37:46.53 Code: 0xC0016016 Source: Description: Failed to decrypt protected XML node "PackagePassword" with error 0x8009000B "Key not valid for use in specified state.". You may not be authorized to access this information. This error occurs when there is a cryptographic error. Verify that the correct key is available.End ErrorPackages are defined as "EncryptSensitiveWithUserKey" and owned and authored by the same user. Does anybody know what to do? |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-02-17 : 07:49:50
|
Are you using same execution command when running the package manually as when when you do in a job?It doesn't seem so.Change to last tab in Execute Package Utility and copy the command line from there.
E 12°55'05.63"N 56°04'39.26" |
 |
|
|
Tasta
Yak Posting Veteran
60 Posts |
Posted - 2009-02-17 : 09:03:21
|
| When running in CMD I use "dtexec", but in SSIS package I see no option to define command. it's the package P1 with "Execute package task" from Toolbox that calls package P2, and I'm trying to run job that contains package P1 only, that doesn't run. While "dtexec P2" works perfect. |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-02-17 : 09:15:33
|
You can set same command for SSIS package as you have with DtExec.
E 12°55'05.63"N 56°04'39.26" |
|
|
|
Tasta
Yak Posting Veteran
60 Posts |
Posted - 2009-02-17 : 10:04:58
|
| Can you explain how? |
|
|
|
|
|
|
Error Failed to decrypt protected