• KoldCoffee (3/17/2014)


    And what files would be a reasonable way to ask for from someone intending to share their ssis package with you? This ssis package exists on that person's computer in whole...so doesn't it seem reasonable to just ask they resend it with the files I need?

    SSDT 2012 changed a large amount of things with SSIS packages, one being design structure. They included project level control of connections which are seperate files to the DTSX files.

    I would generally not share the actual DTSX files for projects I have worked on simply because they contain client/company specific information. I don't know to many folks that actually share DTSX files between each other.

    If you know the person well just ask them if and what they can send you. Just tell them you can't get the file to open to reverse engineer it. Otherwise open up Notepad and start reading through it, the XML is actually not that hard to read through and get the gist of what is going on.

    Shawn Melton
    Twitter: @wsmelton
    Blog: wsmelton.github.com
    Github: wsmelton