5 Tips for a Smooth SSIS Upgrade to SQL Server 2012

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 can help to make the upgrade to Microsoft SQL Server 2012 Integration Services successful. The tips address editing package…


Raw File Improvements

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 honors the sort info The Raw File Destination UI now has a “Generate…


Package Configuration File Editor

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 in Business Intelligence Development Studio (BIDs). Package configuration paths can become invalid when…

2

The Pivot Transform – Now with UI!

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 data from the AdventureWorks sample database. We’ll be…


SSIS and PowerShell in SQL Server 2012

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 a set of APIs that allow you to automate…


What’s New in SSIS for SQL Server 2012 RC0

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 more details over the next couple of weeks. Top…