April 13, 2020 at 2:00 pm
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 .
April 13, 2020 at 2:27 pm
What are you importing the package to? An SSIS project?
The absence of evidence is not evidence of absence.
Martin Rees
You can lead a horse to water, but a pencil must be lead.
Stan Laurel
April 13, 2020 at 2:41 pm
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.
April 13, 2020 at 4:04 pm
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