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

XML Export to individual files Expand / Collapse
Author
Message
Posted Tuesday, March 18, 2014 9:40 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 4:16 PM
Points: 31,284, Visits: 15,748
Looking for an article that takes data from an XML column in a table and exports each field as a separate document.

Separate articles for each technique (SSIS, PoSh, etc).







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1552270
Posted Monday, July 7, 2014 7:23 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Yesterday @ 11:04 AM
Points: 89, Visits: 156
Hello,

I was able to come up with a SSIS package that reads an XML column into a recordset and then uses s script component to output the data for each record into it's own XML file. Is this what you were looking for? I can go ahead and submit the article, just wanted to check if this is what you had in mind when writing this suggestion.

Thanks,
Camille
Post #1589850
Posted Wednesday, July 30, 2014 9:07 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Yesterday @ 11:04 AM
Points: 89, Visits: 156
Submitted an article that goes over the steps to do something similar to this.
Post #1597800
Posted Wednesday, July 30, 2014 1:57 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 4:16 PM
Points: 31,284, Visits: 15,748
Thanks, I'll take a look as soon as I can.






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1597948
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse