When I looked at a simmilar issue I tried 2 ways. 1 - Using ActiveX script in the transformation. 2 - Loading the file into a staging table with no...

I skin my cat this way - I create a sql task who's connection is the spreadsheet and drop the table and recreate it. eg. drop table err_screwup go create...

We do it all the time, some of our users want a history of data rather than using XL to get external data, which I would prefer as it’s less...

Most DBA's I know only care about their precious database and how well it runs. Weather this is because they have always been excluded from the commercial side of...

Thanks for your help guys.

I did some tests on the example I gave you, ordering them small - large shaved 20% off run time and the query plan looked better.

However,...