Sun 15 Mar 2009
ETL World Record – 1 terabyte loaded in 30 minutes
Posted by Phil Brammer under SSIS , SSIS Advanced Techniques , SSIS Data flow[2] Comments
I know, this isn’t “breaking” news or anything, but what is new is the white paper detailing how Microsoft was able to achieve this record breaking speed using SSIS. Check it out below as its a very interesting read, and it may help generate some new ideas for your implementations.
http://blogs.msdn.com/sqlperf/archive/2009/03/03/an-etl-world-record-revealed-finally.aspx
May 20th, 2009 at 1:50 pm
I’m lucky to load 1 MB in 30 minutes.
May 27th, 2010 at 6:26 pm
I like this research post reference and my test results amazing.