Viewing 9 posts - 1 through 9 (of 9 total)
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...
December 5, 2008 at 7:08 am
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...
December 5, 2008 at 6:38 am
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...
December 5, 2008 at 6:13 am
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...
December 5, 2008 at 5:44 am
Great article, thanks for sharing
September 22, 2008 at 10:08 am
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...
April 9, 2008 at 8:48 am
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...
March 10, 2008 at 6:09 am
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...
January 31, 2007 at 4:28 am
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...
January 18, 2007 at 2:11 am