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 |
|
carumuga
Posting Yak Master
174 Posts |
 Posted - 2008-10-03 : 08:41:34
|
| Hi,I have a package which invokes a subpackage using execute package task, intially i got an error (Failed to decrypt protected XML node "PackagePassword"...) because of the encryption and finally changed to "rely on server storage" during deployment of the package to the server. Now, I could able to run the package from the server but not from job. Is there any issue with the deployment. Pls. help me. |
|
|
steve.hebert_1970
Starting Member
3 Posts |
Posted - 2008-10-03 : 08:54:38
|
| I have had lots of trouble with security as well.I shut off the security in the properties and generate config files for the data connections.then when you create the job for the SSIS package there is a location to point the Job to your config files.Steve |
 |
|
|
|
|
|
Deployment - Execute Package task