- Posts: 110
- Thank you received: 0
?XML Type? causing Invalid Descriptor Index
- brillsupport
- Topic Author
- Offline
- Premium Member
-
Less
More
9 years 11 months ago #8362
by brillsupport
?XML Type? causing Invalid Descriptor Index was created 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.
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.
Please Log in or Create an account to join the conversation.
- brillsupport
- Topic Author
- Offline
- Premium Member
-
Less
More
- Posts: 110
- Thank you received: 0
9 years 11 months ago #8364
by brillsupport
Replied by brillsupport on topic ?XML Type? causing Invalid Descriptor Index
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.