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 Import Expand / Collapse
Author
Message
Posted Tuesday, March 18, 2014 9:38 AM


SSC-Dedicated

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

Group: Administrators
Last Login: Yesterday @ 6:20 PM
Points: 33,078, Visits: 15,192
Looking for a basic article that imports a series of XML files in a folder into a table. There should be some element in the XML documents that maps to a PK or other value in the table.

Separate articles for SSIS, PoSh, or other techniques.







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1552266
Posted Tuesday, April 1, 2014 4:01 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, July 25, 2014 9:15 AM
Points: 6, Visits: 114
I should be able to write on an SSIS-driven ETL process using XML files as a source and also touch on XML validation.

Matthew J. Pettit
Post #1557257
Posted Wednesday, April 2, 2014 9:17 AM


SSC-Dedicated

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

Group: Administrators
Last Login: Yesterday @ 6:20 PM
Points: 33,078, Visits: 15,192
That would be good, but a basic, simple, 2 pager on importing separately would be good.






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1557556
Posted Wednesday, April 2, 2014 11:47 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, July 25, 2014 9:15 AM
Points: 6, Visits: 114
Not a problem. I can instead focus on reading and inserting XML files using T-SQL and follow up at a later time with an article on a simple iterative data flow for a collection of XML files.

Matthew J. Pettit
Post #1557631
Posted Monday, April 7, 2014 11:22 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, July 25, 2014 9:15 AM
Points: 6, Visits: 114
Article submitted. I would like to submit a follow up article next month on building a simple SSIS ETL process for importing multiple XML source files.

Matthew J. Pettit
Post #1559200
Posted Monday, April 7, 2014 12:08 PM


SSC-Dedicated

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

Group: Administrators
Last Login: Yesterday @ 6:20 PM
Points: 33,078, Visits: 15,192
Excellent, and thanks.

Always feel free to submit anything else. These are just specific ones I noticed we needed.







Follow me on Twitter: @way0utwest

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

Add to briefcase

Permissions Expand / Collapse