blogs.conchango.com

Here's a useful page to keep an eye on: http://msdn2.microsoft.com/en-us/library/ms403408.aspx. It lists the current features within SSIS that will be disappearing in future versions and the strongest message I take from it is that you should upgrade your existing DTS packages from SSIS sooner rather than later. Currently it also makes ...

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 ...