Today I’ve found a bug in SSIS Pivot Transform component reported as a question in TechNet forums here. Reported issue was related to pivoting some records based, result of PIVOT transformation in SSIS was not as expected to be. read below for detailed explanation; Scenario Explanation: This is a sample of incoming data set: The Read more about PIVOT Transformation Issue in SSIS[…]
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[…]
Sometimes, you need to use PIVOT in SSIS. brief explanation of what PIVOT is from msdn is here: PIVOT rotates a table-valued expression by turning the unique values from one column in the expression into multiple columns in the output, and performs aggregations where they are required on any remaining column values that are wanted Read more about PIVOT Transformation – SSIS – Complete Tutorial[…]