V R MSBI-Xperts: Differences between SSIS 2005 & SSIS 2008 // SSIS 2005 Vs SSIS 2008

Character	SSIS 2008	SSIS 2005
1. Scripting Engine changes	SSIS 2008 uses VSTA (Visual Studio 2005 Tools for Applications) for scripting engine.	SSIS 2005 uses VSA (Visual Studio for Applications) for scripting engine.
	So we can write VB & C# coding also in Scripting of SSIS Packages	2005 only enabled the users to write the scripts in only VB
2. New Tasks	New Data Profiling Task & Viewer	Not there
3. Enhancements( Lookup,	Enhanced Performance and Caching for the Lookup Transformation
4. Enhancements @ Data Flow Task	Enhanced Data Flow Engine Tuned for Parallelism
5. Excel enhancements	Importing Excel 2007 worksheets is native to SQL 2008	. In SQL 2005, you have to build a new connection based on the office 12.0 OLEDB client.
6. Cache Enhancements	you can cache lookup data from any type of data source (not only an OLE DB source)(Named Cache)	you can cache lookup data from only an OLE DB source
7. Source & Destinations changes	SSIS 2008 now includes the ADO.NET source and destination components	The ADO.NET source replaces the DataReader source in SSIS 2005
8. Data Type Changes	DT_DBTIMESTAMP2 is one of the new date/time data types supported in SSIS 2008.	These new types let you work with a wider range of date and time values than in SSIS 2005
9. Look Up	2008 it has an additional feature “No match Out-Put” including Fail Component, Ignore Failure and Re-direct row	In 2005 for Error Output look-ups had only 3 options Fail Component, Ignore Failure and Re-direct row.