?XML Type? causing Invalid Descriptor Index

More
9 years 11 months ago #8362 by brillsupport
I am transforming from one DB to another and the Target and Source tables have identical structures.

There are two XML Type fields in the tables. With empty source table the transform does not produce errors, but as soon as I have 1 or more rows of data in the Source table I get 3 "SQLGetDataA Failed: 07009 [Microsoft][SQL Server Native Client 11.0]Invalid Descriptor Index" error messages and 1 "Access Violation message". This occurs without data in the XML Fields.

I have attached sample data, transforms and screenshots.
Attachments:

Please Log in or Create an account to join the conversation.

More
9 years 11 months ago #8364 by brillsupport
I was just now able to write pure SQL and load the data that way, so you can make this a low priority for your team.

Please Log in or Create an account to join the conversation.