Do you have to have SQL Mail set up to use xp_sendmail?

Success!! Once release 5.6 of WSH was installed on my NT server my script ran successfully both in batch and via dts.

Thanks everyone.

Also, thanks to swjs for...

I just created a .vbs file to execute my script outside of dts. It works ok in W2K, but when I moved it to my production server (Win NT)...

Here is the code. Also, if you have a more efficient way of doing the file name formatting, I would appreciate the info as well. It doesn't seem...

It doesn't seem like WSH is the problem because IE 5 is installed. Any other suggestions?

I figured out what to do. I used the sql query option instead of the table name option to select the table columns and used a convert(varchar, date, 121)...