Unable to execute the saved SSIS package.

20 pts.
Tags:
DTS
SQL Server 2005
SSIS
I have two servers server1 and Server2 both has SQL Server 2005 installed.Server1 has Enterprise Evaluation Edition SP1 and server2 has Workgroup Edition SP2.Since server2 has workgroup edition I cannot open the saved SSIS package in server2. So I connected from server1 created a DTS package and saved it.After this I opened the package by connecting to Integration services and executed the project. But I get a error Error: The AcquireConnection method call to the connection manager "DestinationconnectionOLEDB" failed with error code 0XC0202009. If I execute the same SSIS package with execute immediately and save SSIS package the package executes successfully.But if I open the same saved package next time and execute I get the same error. Please help me to figure out why this happens when a package can execute successfully while the same saved package throws out error when opened in SSIS.

Answer Wiki

Thanks. We'll let you know when a new response is added.

It sounds like there is a problem decoding the credentials when opening the saved package. When you setup the package what encryption level did you select?

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Denny Cherry
    Check out my SQL Server blog "SQL Server with Mr Denny" for more SQL Server information.
    66,290 pointsBadges:
    report
  • MNA
    I always choice Do not save sensitive data and save the project or import the saved project.
    20 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following