July 7, 2016 at 3:42 am
Hi,
Being a Newbie to SSIS, I am trying to get what things I need to develop from scratch as end to end process for XML data to SQL Tables.
I have bit knowledge how to use XML Source and XML Task, but what I am looking is the whole procedure.
Eg:
1) Unzip XML Files (Daily Basis) (Mulitple XML files we received)
2) Create a table to Identify Which XML Files are in Folder, and indicate which files are processed in Actual Table
3) Create SSIS package to do Data transformation from xml to sql table.
I believe I am missing some information, like how many tables do I need to create for validating which XML files are processed, which files are failed, and other information. Please someone who have worked before XML with SSIS, Could give suggestion on it.
That will be great.
Thank you
July 7, 2016 at 5:16 am
That's a good step indeed.
XML is platform independent technology and very powerful.
To start with refer to this URL: https://www.mssqltips.com/sqlservertip/3141/importing-xml-documents-using-sql-server-integration-services/
XML data processing involves shredding, parsing, transformations using XSD stylesheets.
Also the multilevel XML processing creates or loads data into multiple database tables, you may refer to this link: https://learnbymyblog.wordpress.com/2014/08/07/how-to-parse-multi-level-xml-using-ssis/
Hope this helps you to start with XML processing with SSIS.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply