PIVOT Transformation – SSIS 2012 – Complete Tutorial

Posted by on Dec 30, 2012 in SSIS | No Comments

Following the previous PIVOT Transformation Tutorial which was in 2008 R2 and earlier versions of SSIS, I got some feedback recently to create new version of that Tutorial for PIVOT transformation in SSIS 2012. Fortunately Pivot Transformation GUI improved too much in SSIS 2012 and you don’t need to set PivotUsage in the Advanced Editor ...

Read More

SSIS Catalog: Part 1 – What is the Catalog?

Posted by on Jul 28, 2012 in SSIS, SSIS Catalog | One Comment

In this new series of posts I will explain SSIS Catalog of Integration Services 2012. Part 1 – What is the Catalog? SSIS Catalog is a new repository model for Integration Services, which introduced from SQL Server 2012. This new repository model brings a lot of abilities for developers, testers and administrators.  SQL Server Integration ...

Read More