Tag Archives: Excel

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

The Excel Connection Manager is not supported in the 64-bit version of SSIS

As most new PCs are shipping with a 64-bit OS this is becoming a more common error.  I always forget how to resolve this and have to look it up so I thought if I wrote about it in a … Continue reading

Posted in SQL Server Integration Services | Tagged , , , , | 54 Comments