I have a DTS job that copies a very large(slow) view from our HR
database to a table called "hr" on another server. A bunch of our apps
need to use this hr table to do joins so I have a second DTS jobs that
copies the "hr" table to other databases.

Occasionally, for reasons I can't yet pin down, I get an empty "hr"
table because the DTS job deletes first and copies second.

Is there any way for me to check if this table is empty before I copy
it to the other databases?

I checked out sqldts.com and the only reference I could find was a
check to see if a file existed.

Any help GREATLY appreciated.