About Data Profiling Task in SSIS 2008

It was hard in the beginning to get started with the Data Profiling as I was looking for "how-to" information and happily found them all in a precise series of Jamie and John Welch has stepped ahead to show how the XML of Data Profiling task taken from the Package can be used to profile all the tables in a database (That's a clever attempt...) and Curious .. when Matt Masson will announce the release of Refresh CTP that can allow us to assign expressions directly on Data Profiling task via expression builder? Unfortunately you need to wait. In the meanwhile he has blogged about compromizing this functionality by accessing a data Profile programmatically with a well commented, easy lines of code. I would like to extend here, if Microsoft can integrate the Data Profile viewer into SSIS Package (like a browser tab or dataviewer to see results on the fly) adding bit more visualization enhancements, it would be of great help.

Thanks,
Subhash Subramanyam

Comments

Pedro said…
Dear Subhash,
Everything is ok?
Cheers!!

Popular Posts