September 26, 2012 at 7:52 am
I have worked with importing an XML file but not working with XSD files.
A client sent over a bunch of XSD files to analyze.
Can someone point me to a good site and or book?
I'm looking to see how this ties in to SSIS etc...
Marshall
September 26, 2012 at 8:12 am
Jonathan Marshall (9/26/2012)
I have worked with importing an XML file but not working with XSD files.A client sent over a bunch of XSD files to analyze.
Can someone point me to a good site and or book?
I'm looking to see how this ties in to SSIS etc...
Marshall
XSD files are schema files for XML. This is somewhat like your table structure (ddl) in sql server. No clue what you are trying to do or why you need the schema but I am guessing you are going to be getting some xml files from this client and you need to import them to sql? The XSD is your schema and you will need to convert that create table statements.
Here is a decent primer on XSD. http://www.w3schools.com/schema/schema_example.asp
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
September 26, 2012 at 8:22 am
Thank you this greatly appreciated.
September 26, 2012 at 8:24 am
Jonathan Marshall (9/26/2012)
Thank you this greatly appreciated.
You are welcome. I hope that gives you enough of a push in a direction to get done what you need.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply