Balanced Data Distributor (BDD) for SQL Server 2012 is Now Available

The Balanced Data Distributor (BDD) transform has updated and released for SQL Server 2012. The BDD transform makes it easy to split your data flow up on a buffer-by-buffer basis. The two primary scenarios for it are when you want to do parallel inserts into a destination… … and when you want to parallel work…


SSIS Presentations from SQL Bits Available Online

Three slide decks from the SSIS presentations I did at SQL Bits X in London have been posted online. These include: SSIS Performance Design Patterns – full day training session! What’s New in SSIS for SQL Server 2012 – breakdown of the new features and functionality in SQL Server 2012 SSIS Catalog – Overview of…


SSIS Catalog – Backup and Restore

Integration Services catalog (SSISDB) uses the encryption mechanism available in SQL Server to protect its sensitive data. So backup and restore of SSIS catalog across machines need some extra steps in addition to the usual backup and restore steps. This post describes all the steps involved in backup and restore of SSIS catalog. Backup 1….


Changing Variable Scope and other Enhancements

In SQL Server 2012, SSIS includes some very useful enhancements to package variables. You can now change the scope of an existing package variable. Just select the variable in the Variables window and click the new Move Variable icon. Then, in the Select New Scope dialog box, select the package, or a package container, task, or event…

4

Script Component Debugging in SSIS 2012

In SQL Server 2012, you can now debug the Script component by setting breakpoints and running the package in SQL Server Data Tools (replaces BIDS) .   When the package execution enters the Script component, the VSTA IDE reopens and displays your code in read-only mode. After execution reaches your breakpoint, you can examine variable values and step…

18

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…


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…