SSIS – Export all SSIS packages from msdb
SSIS – Why is my data flow so slow with an OLE DB Command component?
So, in response to Jamie Thomson’s article on extracting all SSIS packages from msdb, I also wanted to show how this can be done from within SSIS itself. It’s very straightforward, and uses a data flow component you may not be familiar with: Export Column.
SSIS – Avoiding the Sort Components
“Why does my data flow take so long to execute when I use an OLE DB Command component? “I need to update values in another table for every row in my data flow.” These are common questions I see when dealing with “slow” performance of an SSIS package. Sometimes though, the developer of the package […]
SSIS – Lookup Cache Modes – Full, Partial, None
When using a Merge or Merge Join component in a data flow, your incoming data is required to be sorted. While it may be easy to drop a Sort component into your data flow, it may make more sense to perform the sort in your source query (if you are using a source such as […]
ETL World Record – 1 terabyte loaded in 30 minutes
There are many, many resources out on the ‘Net regarding SSIS and the Lookup component and what each of its cache modes are and how to implement them in your own package. This is going to be a technical post, for those of you interested in what each cache mode does behind the scenes.
SSIS – Lookup component CaSE gotcha
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
SSIS – Stored Procedures and the OLE DB Source
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 […]
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 […]