This article describes a way using SSIS to shred a XML column from a source table into its respective columns in the destination table.  Read more...

This SSIS package generates XML invoice documents from data stored in SQL Server, then FTPs and/or Emails them to clients.  Read more...

This article demonstrates how to build an SSIS package that generates an XML invoice document from data stored in SQL Server and saves it to an XML file.  Read more...

This SSIS package performs multiple XSL transformations on an XML document, then shreds the transformed document and inserts its data into a SQL Server table.  Read more...

Second in the series of tools & techniques to help manage aspects Of Enterprise BI implementation.  Read more...

Package configuration files are a great way of providing the values of SSIS package properties so that packages can be used in a far more versatile way. They make the deployment of SSIS packages easier and can provide parameters that are based on the server configuration, or which change for each runtime. They're easy to understand, especially when explained by Rob Sheldon.   Read more...

Send SQL query results as HTML-formatted e-mail using SQL Server Integration Services.  Read more...

This article brings us an SSIS package that reads an XML file and sequentially displays each XML record in a MessageBox before inserting it into a staging table. You can use this to get XML data into your SQL Server database for further processing.  Read more...

Follow a detailed walkthrough of using the Web Service Task to connect to a web service and return an XML result.  Read more...

Send SQL query results as HTML-formatted e-mail using SQL Server Integration Services.  Read more...

This article provides a step by step guide on how to create and configure an SSIS package which can be used to import XML data  Read more...

Send SQL query results as HTML-formatted e-mail using SQL Server Integration Services.  Read more...

Getting a result set of XML is the easy part, but what about exporting the data in a human readable format? Most DBAs don't spend a lot of time formatting XML output, but it doesn't hurt to know how. New author David McKinney brings us a technique for generating an XML article and then using SSIS and XSL to transform it into an HTML page.   Read more...

Getting a result set of XML is the easy part, but what about exporting the data in a human readable format? Most DBAs don't spend a lot of time formatting XML output, but it doesn't hurt to know how. New author David McKinney brings us a technique for generating an XML article and then using SSIS and XSL to transform it into an HTML page.   Read more...

Marcin Policht continues his discussion of various types of actions that can be performed using XML Control Flow task, focusing this month on the operation type called XPATH.  Read more...