This article describes how to use variables in SSIS to dynamically generate folders and file placement.  Read more...

This white paper introduces Microsoft SQL Server developers to the international features of Microsoft SQL Server 2005. Topics covered include an explanation of Unicode, added support for supplementary characters in SQL Server 2005, the changes in collation in different versions of SQL Server, changes in data types, performance, updates on data providers, and new international support features in SQL Server 2005 Analysis Services and Integration Services.  Read more...

This article explains how to import text files using SSIS in those cases where the text files have different formatted data on different rows. The solution recommended involves minimal coding and is highly maintainable.   Read more...

Longtime author Paul Ibison brings us a short look at a common problem in Integration Services: your source has no column names.  Read more...

This white paper enumerates the connectivity options for databases with Microsoft SQL Server 2005 Integration Services and mentions special considerations that are required when using some database sources with some of the more complex transformations.  Read more...

Continuing on with his series on reporting for your SQL Server, David Bird brings together the series with the full package used for building the report.s  Read more...

Integration Services is a great ETL tool, allowing you to build complex and dynamic transformations. New author Marie Deschene brings us a  Read more...

After completing a project with SQL Server 2005 Integration Services, author G Vijayakumar brings us his technique for an automated scheduling of various source data into a data warehouse with multiple packages.  Read more...

Manage SCD (slowly changing dimensions) by running SCD wizard in SQL Server Integration Services (SSIS) 2005 to track changes in a data warehouse.  Read more...