Guest Columnist: Stan Kulp

An SSIS ETL package created with the Import/Export Wizard uses a Data Flow Task to process one data file at a time. If the need arises, however, the Data Flow Task generated by the wizard can be embedded inside a Foreach Loop Container to batch-process a continuous stream of data files.  Read more...

This article demonstrates how to trigger an SSRS subscription to email a report from an Execute SQL Task using SQL Server Agent and the ReportServer.dbo.AddEvent stored procedure.  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...

In Part 2 of this series we will shred an XML document and insert its records into a SQL Server table using both the OpenXML and XQuery methods.  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...

This article demonstrates how to generate an XML stream from SQL Server using the 'FOR XML PATH' statement, and how to explore that XML stream interactively using an XSL transformation.  Read more...

Distributed queries on linked servers are not the greatest idea from a performance standpoint, but they can be quite useful.  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 SSIS package reads the first line of a CSV file to obtain field names, then creates a table based on those field names and loads the remaining lines into the table.  Read more...

SSIS features log-providers that can write to five different types of logging destinations; three of them are files, one is the 'dbo.sysssislog' table, and the last is the Windows Event Log.  Read more...

A Multicast Transformation can be used to write the same data file to multiple network folders, but it can be tedious and time-consuming to set up as the number of destination files grows. Learn how you can use this transformation in this article by Stan Kulp.  Read more...

This article demonstrates basic C#.NET code that will enable SSIS package developers to write useful custom SSIS script tasks.  Read more...

This article demonstrates basic VB.NET code that will enable SSIS package developers to write useful custom SSIS script tasks.  Read more...

A data flow task generated by the SSIS Import and Export Wizard can be configured to extract data from multiple files by changing the default connection manager to a MultiFlatFileConnection.  Read more...

This article shows how to extract multiple files from multiple sub-directories into a destination table using a single Data Flow Task created by the Import/Export wizard.  Read more...

A new feature of SSRS 2008 R2 is the ability to name sheets in exported Excel workbooks. This article explains how to utilize this feature.  Read more...

This article demonstrates how to manage the development of complex queries by building them in stages with temporary tables, table variables and common table expressions.  Read more...

SSIS 2005 and 2008 have an FTP Task component, but no SFTP (SSH/TLS-encrypted FTP) Task component. This tutorial explains how to overcome this omission.  Read more...

This SSIS package monitors the execution of any SSIS tasks pasted into its sequence container, and sends an email when a failure of any embedded task occurs.  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...