SQL Server 2012 – Integration Services (SSIS) Enhancements – Learning Resources

SQL Server 2012 – High Availability Enhancements – Learning Resources
SQL Server 2012 – Database Engine Enhancements – Learning Resources
SQL Server 2012 – Transact-SQL Enhancements – Learning Resources
SQL Server 2012 – Data Quality Services (DQS) – Learning Resources
SQL Server 2012 – Integration Services (SSIS) Enhancements – Learning Resources
SQL Server 2012 – Analysis Services (SSAS) Enhancements – Learning Resources
SQL Server 2012 – Reporting Services (SSRS) Enhancements – Learning Resources
SQL Server 2012 – Power View – A New Self Service BI Tool – Learning Resources
SQL Server 2012 – PowerPivot – Enhanced Self Service BI Tool – Learning Resources
SQL Server 2012 – SQL Server Management Studio (SSMS) Enhancements – Learning Resources
SQL Server 2012 – SQL Server Data Tools (SSDT) – A New IDE – Learning Resources
SQL Server 2012 – Other Features & Enhancements – Learning Resources


SQL Server Integration Services (SSIS) has undergone a drastic change in SQL Server 2012 with various enhancements and new features. Below is a quick summary of various newly added and enhanced features along with links and references for further learning.

Usability Enhancements

New Features

Enhanced Features

  • Task Execution Status Indicators: In previous versions of SSIS, the color of entire Task used to change to indicate the status of execution of a task (Red – Failed, Yellow – In Progress; Green – Succeeded). In this version of SSIS, the indicators have been improved and only a circle is displayed on the top right corner of the Task along with appropriate color (like in previous versions) along with appropriate symbol (Tick Mark for Success, “X” mark for Failure etc.).
  • Enhanced Pivot Transformation Editor: In previous versions of SSIS, this was a generic editor. In this version of SSIS, the editor has been improved and is much more intuitive.
  • Simplified Row Count Transformation Editor: Previously Row Count Transformation had a generic editor with many read-only properties which were not even so relevant. Now, Row Count Transformation has it’s own editor with only one property to configure and that is the Variable to hold the Row Count.
  • Simplified Data Viewer addition option:

Links and References on Usability Enhancements

Functionality Enhancements

New Features

Enhanced Features

  • Scripting (Debugger): Script Component debugging has been introduced.
  • Flat File Source: Now allows Variable Number of Columns and Embedded Qualifiers.
  • Merge and Merge Join Transformations: Performance of Merge and Merge Join Transformations have been enhanced and now they come with much improved Memory Management capabilities.

Additional Links & References

Blogs/Sites/Forums

Virtual Labs

Videos

White Papers/Guides

Introducing Microsoft SQL Server 2012

Advertisements

About Dattatrey Sindol (Datta)

Datta is a Microsoft BI Enthusiast, passionate developer, and a blogger. View Full Profile

Posted on September 17, 2012, in SQL Server, SQL Server 2012, SSIS and tagged , , , , , , , , , , . Bookmark the permalink. 2 Comments.

  1. Thanks for adding few of my blog links ! You really have done nice collabration of links ! need to bookmark this page !

What are your thoughts?

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: