Thank you so much! That was it.

You're a lifesaver...love this website!

Thanks for the tip of using Tab delimted,

renamed to XLS. It works great!

Using xp_sendmail, do any of you know a way to change the default attached message from

.txt to...

Just had to reply since I just had this

problem as well. I'm doing this:

alter table tblname disable Trigger all

To get by and then enabling it when update

is done.

Thank you for the ideas of things to check.

Nothing has come up in the logs or files. Nothing is running on the destination server and backups are done way...

I just received a simliar error today on one of our jobs that failed after running for almost 2 hours.

DTSRun OnError: Transfer Sql ServerObjects, Error = -2147220299 (800404B5).

Can't find reference...