SSIS Team Now Hiring!

The SSIS team is now hiring developers! Would you like to be a key part of a successful team that is rapidly increasing its impact on the multi-billion dollar Data Integration market? Are you enthusiastic about data integration, transformation, performance and scalability? If so, come join the SQL Server Integration Services team. We are a…


Small Changes to the SSIS Team Blog

Now that the MSDN blog platform supports having multiple authors (ok, it’s supported it for years, but I only just figured out how to do it…), we’re going to start seeing a lot more posts from other members of the SSIS team. I will continue writing about SSIS, but will (mostly) be posting to my…


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…


SSIS at the 2011 PASS Summit

The PASS Summit Schedule Builder is live, and I’ve spent the morning looking over all of the great sessions they have lined up. I always find putting together a schedule challenging – it’s hard to balance my time between the sessions that I want to attend, the sessions I should attend for career growth, and…


Expression Adorners

A quick post today about SQL Server Denali. BIDS now uses a special icon marker (called an Adorner) to indicate package objects that have expressions set on them. In CTP3, these adorners appear on Connection Managers and Variables. As I mentioned in my session at TechEd, the functionality has been further enhanced since CTP3, and…