Is this you? As a journalist, you can create a free Muck Rack account to customize your profile, list your contact preferences, and upload a portfolio of your best work.
Claim your profile
The following SSIS package can be modified to transform and shred any XML document, provided you create the appropriate XSL stylesheet(s) for the transformation(s), and construct the required XQuery SQL code to shred the desired records from the transformed file for insertion into SQL Server. The XmlTransformation.dtsx SSIS package in the attached demo file archive contains two versions of the Script Task, one written in C# and the other written in VB.NET.
As a journalist, you can create a free Muck Rack account to customize your profile, list your contact preferences, and upload a portfolio of your best work.
