Thanks for the answer! I thought adding rows would cause fragmentation and then possibly rebuilding of index but not adding columns.

Most of them don't, I guess that's probably the reason; but I saw t-sqls which do not do inserts, updates or deletes and they still have 35 Writes for eg.

Yes I know data-driven subscription can handle this. But just because we do not have Enterprise edition of Reporting Services (we use Standard Edition) we have to come up with...

Jack,

Yes I can successfully run the query against the linked server without using variables.

Yes the database server is 2000 and the report server is 2005. That explains why. And I...

That's pretty much what I did.

I add a subscription for the report to be emailed to an email address and schedule the report to run once. Query the table on...

It worked after I changed the ARITHABORT option to True.

Catherine,

Thanks very much for the reply! Yes it worked after I set the option to False and saved it and then went back in and set it to True.

As for...

Ok, I got the error when I was doing this on the server; I then copied the package to my local PC and then executed the Script task it executed...