Post reply

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

  • February 26, 2013 at 6:41 am

    #270999

    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

  • February 27, 2013 at 10:24 pm

    #1591864

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

  • February 28, 2013 at 7:20 am

    #1591975

    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.

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • February 28, 2013 at 8:52 am

    #1592011

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

    thanks

  • February 28, 2013 at 8:55 am

    #1592012

    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.

  • March 5, 2013 at 7:07 pm

    #1593722

    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