BI Thoughts and Theories

A question that comes up occasionally on the forums is how to determine if a file is being written to by another process. It can cause issues if a file is partially written when a source component starts extracting data from it. There is a way to check Read More...

On May 15th I'll be presenting at the Triad SQL Server User Group , located in High Point, NC. The presentation will be focusing on new features in SQL Server 2008 for business intelligence and data warehousing. If you're in the area, please stop in and Read More...

There are a number of new features in the 2008 Lookup Transform. Jamie Thomson posted a good overview of the features , and I recommend reading it prior to this article. One of the new features in SSIS 2008 is the ability to cache the data from the Lookup Read More...

In SSIS 2005, one of the challenges with the Lookup transform was that the SQL used to populate the cache was fixed at design time. You could dynamically pass in parameters to the SQL, but only if you turned on the advanced caching options, which puts Read More...