• KoldCoffee (3/16/2014)


    thanks for replying happycat and shawn. Glad to learn about opening up in notepad and tips for finding version.

    PackageFormatVersion is 6 so 2012!

    So, should I be able to open it even though it is just a dtsx file?

    Yes, you should be able to add it to your current SSDT project. The person that sent you that package file may have deleted the connection manager from the package before sending you the file as it may have contained username/password information.

    You might try creating a new package and adding a connection manager to it then compare that to the other package and see if any sections of XML are missing that deal with the connection manager. You might be able to put in some "dummy" information so SSDT will open the package up.

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