September 21, 2001 at 3:03 pm
I'm using xp_sendmail in SQL Server 7.0 to send the DTS Log File on errors. The proc that calls xp_sendmail is outside the DTS package. Everytime I run the proc it says the file is open. I have the file on my local so I know no one has it open. Even if I close out of Enterprise Manager and try to run the proc, I still get the error (MSG 17912 - which is not in B.O.).
Any help would be appreciated. I'm at the end of my rope.
Thanks,
Jason
September 22, 2001 at 2:15 pm
Does it work ok with other files? Also, have you looked at the actual connections to your machine to see what is open?
Andy
September 23, 2001 at 11:30 am
I have had similar problems with files being held open by DTS. If you run the DTS in EM and allow it to finish. Then close the designer. Then run your proc from QA, does it fail?
Can you post your code?
Steve Jones
September 24, 2001 at 9:30 am
I figured out my problem this morning. Sorry to bother you. It seems that if you are hard coding a path to the attachment you need single quotes around the path. If you use a variable you don't. I think this qualifies as a Gotcha, don't you?
Thanks for your time,
Jason
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply