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

  • 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

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

  • 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.

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

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

    thanks

  • 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.

  • CptCrusty1 (2/28/2013)


    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.

    Check if BIDS Helper[/url] 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/

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply