ETL World Record – 1 terabyte loaded in 30 minutes

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

Read more
SSIS – Lookup component CaSE gotcha

So, one of the pain points in SSIS is that the Lookup Component performs CaSE sensitive matching, as well as retaining any trailing spaces that may be in the data. So be forewarned that when using the lookup component, it may behoove you to use a derived column upstream to TRIM([SSISColumn]) your data to get […]

Read more
SSIS – Stored Procedures and the OLE DB Source

Many users have issues when trying to use a stored procedure in an OLE DB Source component. Here are some tips: Ensure that there is a final select statement at the end of the stored procedure to ensure the correct resultset is returned At the top of the stored procedure as part of the procedure […]

Read more