Thanks Ben. That worked. I thought when you save the script and exit it would keep the references, but apparently not. When I did the Build it saved the reference....

If no-one can tell me how to save the reference permanently I will have to change the Excel file to a macro enabled workbook and run code when user open...

No, I only had the execute flag on. There seems to be more activity on our server this morning. I have run both queries again to get another comparison. I...

Of course you can build your query using the #Results table itself in a subquery or EXISTS clause rather than using a text editor. Just saying it maybe useful to...

I prefer not to drop the results of the #Results temporary table at the end of the script (run it manually when finished with the data). Then you can query...

Thank you Scott. I had to replace TableName with TblName becuase some audit tables had columns with that name, resulting in ambiguous column name errors. The query then ran successfully,...

Hi Scott. What would the SQL statement look like to process all the columns for a table in one statement? The database I am querying has 683 tables containing 5812...

Thanks for the advice Jeff and Scott. I did not know what a firehose cursor was. From what I have read I think I just need to add FAST_FORWARD in...

I did not end up trying to run DTS packages in SQL 2005. My search for answers to my original problem of ODBC sources not being visible was not successful,...

Thanks GSquared. I didn't think of that. I do already have a Dev copy somewhere, so it won't cost us a cent (assuming I can find it).

Thank you very much! I haven't installed it yet but that looks as though it will do the trick.

Thanks. I'm not sure. I will need to look into that suggestion. I'm guessing that I won't be able to keep both our SQL 2000 server and the SQL 2005...

Sorry, I've been too busy in the last few months on a project due to go live next week, so I haven't had a chance to look further into it...

Thanks. I will look into the event sink capabilities. It does sound like what I am after.

Hi Frank. Sorry but I never found what was causing the problem. I had to use the report wizard in order to get the drill down to work.

Regards,

Mark.