Need some assistance here again.
What data type should I use for the variable that I receive from a resultset?
I tried setting it to object, but I encountered some problem later in the stage during the data flow because the XML source adapter cannot get the variable.
I tried setting it to String but get some error during runtime because of invalid datatype.
The main purpose here is actually to get the data from an XML column in a table and populate it into the XML Source Adapter so that I can do some transformations.
Any ideas?
Thanks.Hi,
Yes, this is definitely an issue. In the next release (post- CTP15) you will be able to put the XML result set into a string variable that can then be consumed by the XML Source Adapter. For now, you might be able to work around it with a script component that creates a new string variable and populates it with the data from the object variable. I'm sorry I don't have a better answer for you.
Thanks,
Mark
