June 13, 2006 at 6:25 pm
I have a SP that outputs a valid XML record set. Using a Execute SQL Task, I can put the XML results into a string variable. When I try to use the variable in an XML Source nothing happens and I get no error.. If I access the same XML from a file, I get the desired results.
Any ideas why?
June 16, 2006 at 8:00 am
This was removed by the editor as SPAM
June 16, 2006 at 10:48 am
When you say you put the XML into a variable, what do you mean? An SSIS variable? If so, what type - string? when you say 'nothing happens' - what do you mean - does the variable value not change when you look at it in the watch screen?
June 16, 2006 at 11:13 am
I am using an SSIS string variable and have since found out that this problem is a bug that has been fixed in SP1, However, SP1 introduced another bug that an XML greater than 496 characters won't work as a resultset of the Execute SQL task.
June 16, 2006 at 3:15 pm
Hmm - interesting. Have you got a link or reference for those problems?
July 19, 2006 at 12:32 pm
I have a case for this with Microsoft and the issue has been acknowledged as a bug and is being worked on this by their DEV team.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply