Tip needed - Change Connection on several containers at the same time

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 Integration Services » Tip needed - Change Connection on several...

Tip needed - Change Connection on several containers at the same time

Rate Topic

Display Mode

Topic Options

Author

Message

CptCrusty1

Posted Tuesday, February 26, 2013 6:41 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, May 01, 2013 1:17 PM
Points: 158, Visits: 252

I have a DTSX package that I need to change the connections on for about 30 containers. Is there a way to do them all at once, or am I stuck doing this the fun way?

Thanks
Crusty

Post #1424059

pramesh2001

Posted Wednesday, February 27, 2013 10:24 PM

Forum Newbie

Group: General Forum Members
Last Login: Friday, May 10, 2013 12:30 AM
Points: 2, Visits: 26

You can create .NET utility to read dtsx XML format can change variable values.

Post #1424901

Phil Parkin

Posted Thursday, February 28, 2013 7:20 AM

SSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 9:39 AM
Points: 4,247, Visits: 9,500

pramesh2001 (2/27/2013)

You can create .NET utility to read dtsx XML format can change variable values.

This does not answer the question at all.

____________________________________________________________________________________________

Help us to help you. For better, quicker and more focused answers to your questions, consider following the advice in this link:

http://www.sqlservercentral.com/articles/Best+Practices/61537/

If you are asking for help and your post does not contain a question, you should expect responses which do not contain any answers. Put a question mark in there somewhere - it's not rocket science.

Post #1425038

pramesh2001

Posted Thursday, February 28, 2013 8:52 AM

Forum Newbie

Group: General Forum Members
Last Login: Friday, May 10, 2013 12:30 AM
Points: 2, Visits: 26

i have done for the same way, other than this any simple way.. pls share.

thanks

Post #1425081

CptCrusty1

Posted Thursday, February 28, 2013 8:55 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, May 01, 2013 1:17 PM
Points: 158, Visits: 252

I'm not a .Net developer and have very little familiarity with creating utilities so this option wouldn't work for me with out turning it into a project that would require cross-functional collaboration. I'm looking for a quick and dirty method that I can use for the occasional issue.

Thanks
Crusty.

Post #1425082

CozyRoc

Posted Tuesday, March 05, 2013 7:07 PM

Ten Centuries

Group: General Forum Members
Last Login: 2 days ago @ 10:02 AM
Points: 1,106, Visits: 2,115

CptCrusty1 (2/28/2013)

Check if BIDS Helper can help. If not, you can post your idea in the discussion page for the project and it might appear sooner rather than later.

---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

Post #1427120

« Prev Topic | Next Topic »

Permissions