I am trying to create a SSIS package to read data from oracle database and xml file and load it into XML file. The package was built without any error but when I executed the package the data is not read right from XML source transformation and is returning NULL for all the columns.
Am I missing something? Please help!
asked Jun 01, 2011 at 06:35 AM in Default
If NULL for all columns is returned then it probably means that the transformation is correct as far as the xml shape is concerned, but the casing of the node names does not match. For example:
Please check the spelling of the nodes which actually hold desired values to make sure that each one is spelled correctly and the case matches the source.
answered Jun 01, 2011 at 08:24 AM