I have the following data coming in to SSIS from an XML input file
I want to transform it to read
I read the values from the XML source and then using a script component I am trying to using the following logic
However, this part of the script never executes. When I send the values read from the XML file straight to a Flat File destination, it does work, but for some reason this part isn't working.
Is there some setting that I am missing?
It looks like you are close, but you may be complicating it a bit too much. Using Row.NextRow in the script will help you. Sorry about the VB, I have 2005 and don't have C#.
The main problem with your code seems to be that you don't know which row is the last row in the buffer, so you are always going to miss the last "SET".
(Warning, there have been changes in the way 2008 behaves with row.nextRow and it might cause an error. Just make sure that you are getting all of the rows, and not getting duplicate rows. http://blogs.msdn.com/b/michen/archive/2008/10/19/does-buffer-nextrow-skips-the-first-row-in-a-buffer.aspx) This works perfectly in 2005 using VB
answered Jan 18, 2011 at 05:45 PM