Search This Blog

Tuesday, May 12, 2009

SQL: SSIS Package Connection String Error during execution

Issue:
SSIS Package Connection String Error during execution

Other Symptoms:
When job with the package is executed, the job doesn't run successfully

Resolution:
  • When you import the package, ensure to choose 'Rely on Storage Security'
  • Import Package > Protection Level > 'Rely on Server Storage and access contol'

No comments: