blogs.conchango.com

Quite often you may want to process data from multiple files all at the same time. There are a number of options available to you if you want to do this. 1. Have a seperate source adapter for each file and amalgamate them together with the Union All component. Advantages of this approach: This works well if the files are of ...

I have just arrived home from an excellent BI-flavoured meeting of Tony Rogerson's UK SQL Server User Group. Aside from some great content the thing I love about these events is the change to meet up with people from around the BI community - people that I've met both in person and online in the past few years.So Rastko Petrovic, Mat Stephen, ...

Whilst reading posts on the SSIS forum of late it has become evident that people are unaware of the power that expressions can provide within an SSIS package. This is understandable - alot of people are starting to use SSIS now but expressions aren't the most obvious feature. So what are they? Well the most generic explanation is that ...

Peter (sorry, don't know your surname) made a very good comment here: http://blogs.conchango.com/jamiethomson/archive/2006/02/20/2895.aspx#2903 that data-flows in a ForEach loop carry out repeated SELECTs against a data source and it would be good to be able to cache that data rather than executing the same query over and over. Its a great ...