Sunday, October 12, 2008

Abstracting underlying data sources for SSIS packages using Views

In a perfect world, we'd never have changes to the schema once it has been defined. But in practice this is almost never the case.

I stumbled upon this excellent article which provides a solution to minimize the effects of change.

http://bi-polar23.blogspot.com/2008/09/views-as-for-ssis.html

1 comment:

Gayan Balasooriya said...

Hi,
I have added ur blog on my blog list and hope it will be on the top of the list with new good postings.