Sorted, thanks for your help guys!! Clustered indexes had inflated the table size which threw me off the scent about indexing being the root cause.

I had made that change earlier...

I think I may have just solved it, the maintenance reindex job on the 2005 box specified 90% free space!!! I am running the reindex job again now and will...

There are no indexes based on the GUID on the 2000 or 2005 box on this table or any others but this doesn't mean it's not part of the problem...

Thanks for your help.

There is a daily reindex job on the 2000 box which takes 7 minutes to run. The largest table TB_X has 2.3million rows, on disk usage report...

Great article, thanks for sharing

Hi all,

Thanks for the replies but I don't think that is quite what I am looking for. I want to convert the Excel file into a PDF within the SSIS...

Hi Kathi\Mark,

I have numerous SSIS packages that loop through a distribution list populating Excel reports and sending each file directly to clients. Would it be possible to use this product...

Have you tried using an SQL command (or SQL command from variable) as the data access mode for the Excel source?

You can then set SQL command text as select top...

Yep it is, you just won't be able to connect to 2005 through EM. Make sure you have set up linked servers first, we had some security issues so had...