PIVOT Transformation – SSIS 2012 – Complete Tutorial

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 about PIVOT Transformation – SSIS 2012 – Complete Tutorial[…]

SSIS Catalog: Part 1 – What is the Catalog?

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 about SSIS Catalog: Part 1 – What is the Catalog?[…]

My Presentation on New Features of SSIS 2012 – Auckland SQL User Group

Hi folks, I had a presentation on New Features of SSIS 2012 on Auckland SQL User Group at Microsoft NZ venue at 16 May 2012. in following you will find more details about my presentation Session Topic: New Features of SSIS 2012 Description: SQL Server Integration Services (SSIS) is a leading tool in the data Read more about My Presentation on New Features of SSIS 2012 – Auckland SQL User Group[…]

My Session at SQL Saturday 136 – New Features of SSIS 2012 (Presentation and Demo)

Hi folks, April was busy month for me, I was finishing the book from one side, preparing presentation for SQL Saturday 136 and attending at Microsoft exam from other side! SQL Saturday 136 ran at 14 April at Wellington – New Zealand with 14 session, and that was good opportunity for me to meet Rob Read more about My Session at SQL Saturday 136 – New Features of SSIS 2012 (Presentation and Demo)[…]

My Session at SQL Saturday 136 Wellington

Hi folks, the event schedule of SQL Saturday 136 of ANZ 2012 defined already, This event will be in Wellington at 14 April, Agenda of 14 sessions listed here. You can register for this free tutorial day of SQL Server and enjoy it. there are a range of good SQL Server speakers there which I Read more about My Session at SQL Saturday 136 Wellington[…]

My new SSIS 2012 Book Will be Published Soon

Hi friends, after about 7 month hardworking I wants to inform you that my upcoming book about SSIS 2012 will be published about 1 month later, So I like to share the link of the book here. Pedro Perfeito one of my friends who is a SSIS expert and also SQL Server MVP in Portugal Read more about My new SSIS 2012 Book Will be Published Soon[…]