Difference between SSIS 2005 and 2008

The below are the key differences between SSIS 2005 and 2008 .

1. Script Task :

In SSIS 2005 users can write the script in VB only.

In SSIS 2008 users can write the script in C# and VB.

2. DataProfilingTask :

In SSIS 2005 Data Profiling Task is not available.

In SSIS 2008 Data Profiling Task is introduced.

3. Cache Transformation :

In SSIS 2005 Cache Transformation is not available.

In SSIS 2008 Cache Transformation is introduced.

4. Look Up Transformation :

In SSIS 2005 Error Output lookup has only

               Fail Component , Ignore Failure & Redirect Row .

In SSIS 2008 "No Match Output " is introduced along with the existing features.

5. Cache Mode :

In SSIS 2005 Cache Mode is not available .

In SSIS 2008 Cache Mode is introduced with 3 types of cache

                Full Cache Mode , Partial Cache Mode & No Cache Mode .

6. OLEDB Provider for Analysis Services :

In SSIS 2005 OLEDB Provider for Analysis Services is not available .

In SSIS 2008 OLEDB Provider for Analysis Services is introduced.

7. Excel Enhancements :

In SSIS 2005 you have to build a new connection based on the office 12.0 OLEDB Client .

In SSIS 2008 Importing excel work sheets is native to SQL 2008.

8. Data Flow Task :

In SSIS 2008 enhanced data flow engine tuned for parallelism.

What’s new in SSIS 2012 for developers

The below are the new enhancements for developers in SSIS 2012

* Undo and Redo Changes is SSIS PACKAGE.

* SSIS tool box enhancements.

* SSIS design surface enhancements.

* SSIS solution explorer enhancements.

*  Group tasks and Transformations.

*  Decimal Data type variable.

* Expression Character Limit.

*  SSIS toolbox and Variable buttons are added to package design surface.

* Zoom IN and Zoom Out.

*  Parameters are added  in design panel where control flow and dataflow , parameters ,event                  handlers ,Package explorer.

     *   PIVOT transformation , Row Count GUI Transformation  GUI Improvements.

     *  ODBC Source and ODBC Destination.

     * DQS - Data Quality Service is introduced used to enable more easily and accurately improve              the quality of data.