A new whitepaper on upgrading SSIS to SQL Server 2012 is now available . Summary: Microsoft SQL Server 2012 Integration Services (SSIS) provides significant improvements in both the developer and administration experience. This article provides tips that...

There have been a couple of improvements made to the Raw File Source and Destination in RC0 . The Raw file format now contains Sort information The Destination saves all sort info (including the Comparison Flags for string columns) The Source reads and...

A new tool for SSIS 2008 and 2008 R2 is now available for editing package configuration files. The Package Configuration File Editor identifies configuration paths that are not valid and enables you to correct the paths without having to open the package...

One of the post-CTP3 changes for SSIS in SQL Server 2012 is the addition of a user interface for the Pivot transform. This post walks through the new UI, which can be found in the new RC0 preview release. Sample Data For this example, we’ll be pulling...

This post is from Parth Shah, a Software Development Engineer in Test on the SSIS Team. Previously we have talked about SSIS Catalog Managed Object Model . For those of you don’t remember what MOM is or have not heard of it before, think about MOM as...

At the 2011 PASS Summit I presented a Top 10 list of features that had been added since CTP3 , or hadn’t gotten much attention so far. Now that the SQL Server Release Candidate 0 (RC0) available , I can start blogging about them! I’ll continue to post...