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.


  • 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 6 (of 6 total)

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