We have 'jeans' day at least once a month for charity - it is $1.00. Just about everyone participates. The 'company' didn't initiate it, the employees did. ...

SSMS!

It was bringing all the data back to the calling server and then applying the where clause.  This is why the query execution time increased significantly.

Thanks - the DTSBackup works great.

Thank you.

What about transferring a DTS package? Is there a way to do that?