MSBI (SSIS/SSRS/SSAS) Online Training

Monday, March 9, 2009

SSIS – new Features in SSIS 2008

It’s amaging to share about SSIS-2008 is powerful ETL tool in the market.
Am describing some points here.

1.SQL Server 2008- a record for loading data into a relational database using an Extract, Transform and Load (ETL) tool. Over 1 TB of TPC-H data was loaded in under 30 minutes.
2. 1.18TB of flat file data was loaded in 1794 seconds. This is equivalent to 1.00TB in 25 minutes 20 seconds or 2.36TB per hour.
3. Informatica has the fastest time previously reported, loading 1 TB in over 45 minutes. SSIS has now beaten that time by more than 15 minutes.
4.using sqlprofile task we can easily trace the data.

One of the great SSIS developer mattm posted excellent views on his blog’s.


Part one

Part two

No comments: