Yes, I am also looking into that but we need to move to 64-bit sql server ASAP.  I needed something in the interim.

Thanks Mike.  We are also moving to 64-bit Itanium servers and are in the process of testing everything out.  I have moved away from XP_smtp_sendmail and have started using cdonts.  The...

Well..thats fine.  I reverted to cdosys.

Was anybody able to successfully test this on 64-bit sql server?

Eric

I have learned the hard what that exe files should not be called from xp_cmdshell. 

Three options:

1. Debug the code

2. Put print statements after each section of the procedure to identify the section along with select getdate().  See eg. below

Print Section 1 done

select getdate()

The beggest...

I my case, I created a new table (lets say B) with exact same fields as the tables where the data will eventually be loaded (lets say table A). ...