Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Spliting XML file into Parent/Child table using SSIS package Expand / Collapse
Author
Message
Posted Thursday, November 7, 2013 9:16 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, June 27, 2014 4:16 PM
Points: 5, Visits: 15
Thank you very much for taking the time to reply. I apologize for not being more clear, but I was looking for a solution using SSIS and Data Flow tasks - I have figured out how to do this using a Merge/Join Transformation. If anyone needs to do it this way let me know and I will post what I have come up with.

However, the information that you have provided will be helpful as well - it will serve as a good reference for using the SQL nodes function. I have not done much development with regard to querying XML data this way, and always find myself having to research it again any time that it comes up.
Post #1512336
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse