![]() Performance of this process had deteriorated over time and one of the project deliverables was to ensure that job run as fast as possible, extract certain fields from the XML document and ignore the rest. I recently got involved in a data warehouse project and one key requirement on the ETL implementation, was loading and processing very large XML source data feeds daily (About 50 files, each with averages sizes between 7-10GB). In this article, I will be showing how to use the SSIS Script Component to consume XML files. This is even truer given how common distributed systems have become and the need for applications from different sources and protocols to share data and communicate. ![]() One of the common source data files that every ETL Developer/Architect will have to grapple with every now and then is XML source files.
0 Comments
Leave a Reply. |