The "SENDUSING" configuration value is invalid

Question

Post reply

The "SENDUSING" configuration value is invalid

Joseph Kligel

SSC Enthusiast

Points: 189
More actions
March 10, 2008 at 2:43 pm

#98802

I'm doing my first DTS package on SQL server 2000 which is running on a Windows Server 2003 R2 OS
The package works completely on my local machine (win XP) but errors out on the server.
I found a VB script (below) that sends the email.
Again works great on my machine but not the server.
I'm learning has much has I can about sql, dts and stuff and read previous posts...But sorry...It's not clicking yet how to resolve my problem.
Any help will be greatly appreciated
'**********************************************************************
' Visual Basic ActiveX Script
'************************************************************************
Function Main()
Dim iMsg
set iMsg = CreateObject("CDO.Message")
Dim objMail
Set objMail = CreateObject("CDO.Message")
objMail.From = " username@ip.org"
objMail.To = "username@ip.org"
objMail.AddAttachment ( "C:\temp\excel_file.xls")
objMail.Subject="Excel Spreadsheet"
objMail.TextBody = "Spreadsheet"
objMail.Send
Set objMail = nothing
Main = DTSTaskExecResult_Success
End Function
THANKS
Joe

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Jack Corbett SSC Guru Points: 184394 More actions · Answer 1

What is the error you are getting?

I am guessing that Outlook is not installed on the server so you do not have the CDO library available.

Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question

Joseph Kligel SSC Enthusiast Points: 189 More actions · Answer 2

I'm getting the "The "SENDUSING" configuration value is invalid" error.

I installed Outlook on the server but have same error.

Jack Corbett SSC Guru Points: 184394 More actions · Answer 3

Check out this link, http://www.systemwebmail.com/faq/4.2.2.aspx#4.2.2. Looks like you need to explicityly set the smtp server.

Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question

Jacob Luebbers SSCarpal Tunnel Points: 4834 More actions · Answer 4

If you want to avoid DTS for sending your mail you can do it all via OLE automation from TSQL: http://support.microsoft.com/kb/312839

On your specific error - we get exactly that from time to time when using CDOSYS as described in that link. It works fine 99% of the time but after the server's been up for a while and using the CDOSYS mail proc a lot it eventually stops working with that exact error (and yes, we ARE specifying the SMTP server). I suspect there's a memory leak somewhere or a resource that's not being released, and the only solution appears to be a restart of the SQL Server service.

Regards,

Jacob

Joseph Kligel SSC Enthusiast Points: 189 More actions · Answer 5

Thanks Jack and Jacob.

Your advise helped me in my search. I'm still too much a 'newbie' to grasp everything you explained in your responses ( i did understand some) , but I was able to find a stored procedure at "http://www.sqldev.net/xp/xpsmtp.htm#Installation" that did the email using SMTP. It worked great.

Again thanks for your help.

Joe