Unable to import package

  • I treid to import dts package from sql 2012 to sql 2019 and getting error

    Failed to load XML from package filedue to error 0xC00CE508 "An invalid character was found in text content. Line 1, Column3".

    This happens when loading a package and the file cannot be opened or loaded correctly into an XML document. This can be the result of either providing an incorrect file name to the LoadPackage method or the XML file specified having an incorrect format.

     

    how to load the package .

  • What are you importing the package to? An SSIS project?

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

  • I've not yet moved from SQL 2012 to 2019 but in previous database upgrades the SSIS packages have to be rewritten or at least recompiled in Visual Studio.

    I'm interested to know what you need to do to get it working.

  • i deployed the package  successfully  to integration catalogue .

     

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

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