Introduction
This article explains the basic differences among SSIS 2005, SSIS 2008 and SSIS 2012.
Basically, there are no differences between SSIS 2005 and SSIS 2008 at the architectural point of view, but there are additional features added in SSIS 2008.
Differences between SSIS 2005 and 2008
| SSIS 2005 | SSIS 2008 | |
| Script Task | Here users can write the scripts in VB only. | Here users can write the scripts in C# and VB. |
| DataProfilingTask | DataProfilingTask is not in SSIS 2005. | DataProfilingTask is introduced in SSIS 2008. |
| Cache Transformation | Cache Transformation is not in SSIS 2005. | Cache Transformation is introduced in SSIS 2008. |
| Look Up Transformation |
In SSIS-2005 for Error Output look-ups had only the following 3 options.
|
SSIS -2008 added an additional feature “No match Out-Put” to the SSIS 2005. |
| Cache Mode | Cache Mode is not in SSIS 2OO5. |
Cache Mode is introduced in SSIS 2OO8. 3-Different Cache Mode in SSIS 2008:
|
| OLEDB Provider for Analysis Services | SSIS 2005 does not contains an OLEDB Provider for Analysis Services | SSIS 2008 contains an OLEDB Provider for Analysis Services |
GANESH PRASADPosted Dec 10, 2014, 2:35 AM
Could you please let me know how to extract data from multiple excel sheets when the structure of the sheets vary and need to get only the selected columns
GANESH PRASADPosted Dec 10, 2014, 2:34 AM
good info