Welcome to EMC Consulting Blogs

I've been writing about SSIS for quite some time now and probably one of the more popular articles post I have written is this one: Get all from Table A that isn't in Table B (http://www.sqlis.com/default.aspx?311) which I wrote way back in 2004. Its not popular because of the quality of the writing, oh no. Its because of the subject ...

With the advent of SQL Server 2005, Microsoft provided three new T-SQL windowing functions that will turn out to be highly beneficial to T-SQL developers. They are:ROW_NUMBER (Which I have talked about previously here)RANKDENSE_RANKIt occurred to me that the same functionality would be equally beneficial in the SSIS pipeline and to that end ...

Just a short note to tell you about a webcast that is coming up on 25th October 2006. "How to use the DataReader Source and the OLE DB Source objects in SQL Server 2005 Integration Services" The subject matter will be (it says 'ere): This Support WebCast provides an overview of how to effectively configure data flow sources such ...