Monthly Archives: March 2011

SSIS Select Distinct From Excel Data Source

I had to modify an existing SSIS package and found that the author had an Excel data source with duplicate rows in it. The destination needed unique records. The author’s solution was to save the data to a staging table … Continue reading

Posted in SQL Server Integration Services | Tagged , , , , | 1 Comment

Time to upgrade SQL Server 2005

Mainstream support for SQL Server 2005 is ending April 11, 2011.  Time to upgrade those 2005 instances. http://support.microsoft.com/lifecycle/?LN=en-us&p1=2855&x=19&y=13

Posted in Database Administration | Tagged , , | Leave a comment