How can you edit an SSIS package when the connection details have changed?

[Waldy]

Hi there,
I am simply trying to view an existing SSIS package that I
created some time ago. The database settings have changed and I cannot seem
to do anything with the package now. VS hangs for about 10 minutes and
eventually displays a dialog with the message "Could not retrieve a
connection manager for the selected connection object". When you OK that
message, you are presented with a retry cancel dialog. I don't want to
retry, so I click cancel, but that just goes round the loop again. Do I
have to start again, or is it possible to recover an old package?

[tbradshaw via SQLMonster.com]

Hello Waldy,

I'm thinking you meant to post this in the SSIS section. But nonetheless...

Instead of opening your package in Visual Studio, find the actual DTSX file
and open with, say, Notepad. It's simply an XML document, so you can
manipulate elements & attributes as you see fit.

In this case, I would look for a DTS:Property DTS:Name "ConnectionString" and
change it to something to your liking.

Let us know how you make out.

Best Regards,
Tom

Thomas Bradshaw
Data Integration Services
MyWebGrocer LLC