Post reply

Load SSIS package with XML code only

  • July 3, 2018 at 8:52 am

    #365250

    Hi SSC,

    I made a copy of an SSIS package XML. I saved it to notepad with a ".DTSX" extension. I am trying to load that file into SSIS but I keep getting errors. Here are my steps...

    1) Add existing package as file system.
    2) Select the ".DTSX" file.
    3) Error says that the file is not well formed, but I pulled the XML from an existing package that is in production.

    Any help would be greatly appreciated.

    The are no problems, only solutions. --John Lennon

  • July 3, 2018 at 9:02 am

    #1996169

    Lord Slaagh - Tuesday, July 3, 2018 8:52 AM

    Hi SSC,

    I made a copy of an SSIS package XML. I saved it to notepad with a ".DTSX" extension. I am trying to load that file into SSIS but I keep getting errors. Here are my steps...

    1) Add existing package as file system.
    2) Select the ".DTSX" file.
    3) Error says that the file is not well formed, but I pulled the XML from an existing package that is in production.

    Any help would be greatly appreciated.

    Why can't you take an exact file copy of the deployed package?

    Nonetheless, what you are doing sounds like it should work. I wonder whether the package contains any extended characters which are being corrupted in transit.

    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

  • July 3, 2018 at 9:05 am

    #1996170

    Hi Phil,

    I am waiting on access to TFS, so yeah, it would be great if I could just grab the package itself. They only provided me with the XML. It's due Friday, of course 🙂

    Thanks

    The are no problems, only solutions. --John Lennon

  • July 3, 2018 at 9:10 am

    #1996171

    Lord Slaagh - Tuesday, July 3, 2018 9:05 AM

    Hi Phil,

    I am waiting on access to TFS, so yeah, it would be great if I could just grab the package itself. They only provided me with the XML. It's due Friday, of course 🙂

    Thanks

    I see. I think the first thing I would do is compare the XML provided with that from a simple package that works & look for anomalies.

    Use a graphical XML editor if you can ... it makes navigating XML files much less of a chore.

    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

Viewing 4 posts - 1 through 3 (of 3 total)

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