Send Lotus Mail From Script

Apr 9, 2008

Hi Guys,

Im want to be able to send an email from a script via Lotus Notes.

Im trying this code which i found at http://blogs.conchango.com/jamiethomson/archive/2006/07/03/SSIS_3A00_-Sending-SMTP-mail-from-the-Script-Task.aspx


Imports System
Imports Microsoft.SqlServer.Dts.Runtime
Imports System.Net.Mail
Imports System.Net


Public Class ScriptMain
Public Sub Main()
Dim myHtmlMessage As MailMessage
Dim mySmtpClient As SmtpClient

myHtmlMessage=New MailMessage("me@mail.com", "me@mail.com")
mySmtpClient = New SmtpClient("192.168.3.1")
mySmtpClient.Credentials = New System.Net.NetworkCredential ("<username>", "<password>")
mySmtpClient.Send(myHtmlMessage)
Dts.TaskResult = Dts.Results.Success
End Sub
End Class


First the task stayed Yellow and didnt changed, not it gives me the following error:
DTS Script Task has encounter an exception in user code.
Transaction failed. The server response was: Relay rejected for policy reasons.

Could someone help me there or suggest another way for sending Lotus Notes email from my SSIS Package?

Thanx

View 11 Replies


ADVERTISEMENT

Send Mail Task - Succeeds But Does Not Send Mail

Nov 28, 2007

I have attempted to report out errors at the end of an ETL process by alerting supporting DBAs of errors using the SSIS "Send Mail Task". Task completes along with the sequenced packages, but does not mail anything out. No logic at this time for trigger, just success from the previous task triggering the task to send mail. I also get no errors in the output, and I get no output indicating the send mail task fired, but it does go "green". Do I have to enable database mail and have privileges?

Component Configuration:

SMTP Connection Manager - SMTP Server: arsocex02

Send Mail Editor -

From: messerj@arsocdev.bdev.lab.mil
To: sanderss@arsocdev.bdev.lab.mil
MessageSourceType: Direct Input
Expression: MessageSource = "Package>>> " + @[System:ackageName] +" was executed at>>> " + (DT_WSTR, 40) @[System:tartTime] + " by user>>> " + @[System::UserName] + " on Machine>>> " + @[System::MachineName] + " Errors reported to ERRORS_COURSE_CLASS_STATUS_T: " + (DT_WSTR, 50) @[User::ErrorCourseClassStatus]

Thanks



View 7 Replies View Related

Sql Mail And Sql Server Agent Mail With Lotus Notes Domino Server

Jul 7, 2003

Hello Everyone,
I am trying to configure SQL MAIL and SQL SERVER AGENT MAIL feature of SQL SERVER 2000 with Lotus Domino server (Not Microsoft Exchange). Every thing goes fine and it works also. Problem starts when I try to restart SQL Agent Service. It hangs and the status of service remain 'starting'...
Also the size of the sqlagent service process goes upto 12MB. I don't understand why? Can any one help me in solving this problem.
I am using Windows 2000 Advanced Server and SQL Server 2000 with SP3. Domino client is R5.0.5 and Outlook 2000.

View 14 Replies View Related

SQL Mail For Lotus Notes

Jul 18, 2001

Can any one send me a link to step by step instructions on how to setup SQL mail for lotus notes.Thanks for the help!
Reddy.

View 1 Replies View Related

Lotus Notes 5/MS SQL 7.0 Mail

Jul 28, 2000

Hello,

I am using Lotus Notes 5.0 for email and would like to set the MS SQL Server Agent to email failure messages to my Lotus Notes
mailbox. I setup a profile in exchange (after installing Microsoft Messaging) called "Lotus Notes Mail". This profile actually works..
I can send and receive email from microsoft exchange.. But when I go in SQL server agent to setup the mail profile, first of all,
the mail profile drop down list is empty (my profile I created with Microsoft Exchange is not there) so I typed it (Lotus Notes Mail)..
When I click on the TEST button, I get the following error message:

Error 22030: A mapi error {error number 87} occured: MapiLogonEx failed due to mapi error 87: Invalid parameter.

Can someone help?? Does this means that there is something not setup properly in Notes??
Thanks in advance

View 4 Replies View Related

SQL Mail On Lotus Notes

Nov 1, 1999

I have just started a position at a new company and
want to set up the SQLMail option on each of the
20+ servers. One problem I see is that the e-mail
package here is Lotus Notes. Does anyone have any
experience or information they can pass on to me
regarding SQLMail and Lotus Notes? I would appreciate
any advice.

Thanks!
Toni Eibner

View 1 Replies View Related

Help With SQL Mail And Lotus Notes...please

Oct 15, 1998

Hi everyone,

I have read every article in the kb and read every message in the newsgroup but still I cannot make SQL mail to work with lotus notes. Can someone describe in details on how to do this?

Any suggestion is greatly appreciated...

View 2 Replies View Related

SQL Mail Problem At SQL 2000 And Lotus Notes 6.5

Apr 17, 2007

Hello All,



I have an SQL 2000 sp4 default instance.
On windows server 2003 sp2 machine that is joined to a domain.
This windows is not the domain controller.

There is a domain account domainuser.
This domain account is a member of the Administrators group locally in the windows.
Also this domain account is a member of SysAdmin fixed server role of the SQL Server instance.
The MSSQLSERVER service is logged in by this domain account.
The SQLSERVERAGENT service is also logged in by this domain account.

Office 2007 (including outlook 2003) is installed on the same windows server machine that SQL resides in.

Lotus notes cloient 6.5 also installed on the same windows server machine that SQL resides in.

In Control Panel - Mail - Profiles: Outlook is the profile used.

In enterprise manager --> Support Services --> SQL Mail --> Properties --> I wrote Outlook in the profile name --> then click "Test" --> I encounter this error: "Error 18025: xp_test_mapi_profile: failed with mail error 0x80040111"



I looked at

http://support.microsoft.com/?id=263556



I could not figured it out



Any help please?



Thanks,

Ven

View 7 Replies View Related

How To Send A Dynamic Files Attachment By Send Mail Task?

Jan 19, 2007

Hello All,

Hopefully someone out there will have an idea as this is driving me nuts.

I want to send a dynamic files in attachment files ny send mail task that file name has change follow datetime.

I try to use the expression but I can't use it.

please tell me for this problem.

Any suggestions appreciated,

Thanks.

View 4 Replies View Related

SQL 2000 MAPI Mail Interface To Lotus Notes

Apr 23, 2001

I have not yet set up SQL2K mail -> Notes, but I see in Q263556 a warning regarding extended MAPI and non-Exchange servers.

Just wondering if anyone is using a SQL2K - Notes MAPI profile -- and if any reliability issues have come up?

Thanks in advance

View 1 Replies View Related

Integration Services :: Sending Mail With HTML Format In Send Mail Task

Aug 18, 2015

I have to send mail with HTML format  and attaching multiple files dynamically via send mail task.

View 10 Replies View Related

How Can I Send Many Mail In Send Mail Task ?

Feb 27, 2007

Hello All,

Hopefully someone out there will have an idea as this isdriving me nuts

I have some sample problem.I want to send many email in one send mail task, how can i do it?

what is a signal for separate between email address in send mail task.

please tell me for this event.

any suggesstion appreciated

Thanks you very much.

P.Chonnathan

View 5 Replies View Related

SSIS Send Mail Task - Failure Sending Mail

Dec 13, 2007

Dear all,
I have switched off the firewall settings on my system and as suggested im entering the minimal information and data to send the mail.
but still the Mail Task is failing..
plz suggest.

View 11 Replies View Related

SSIS Send Mail Task - Failure Sending Mail

Jun 8, 2006

Hi Everyone,

Hopefully someone out there will have an idea as this is driving me nuts.

I've setup a task to email on success/failure and keep receiving the following message when executed:

Progress: The SendMail task is initiated. - 0 percent complete
[Send Mail Task] Error: An error occurred with the following error message: "Failure sending mail.".
Progress: The SendMail task is completed. - 100 percent complete
Task Send Mail Task failed

When I configure Outlook Express on the same machine with the same settings it works.

On the SMTP Connection Manager I have left the default name, tested with both an IP address and Server Name, and no authentication or SSL.

On the Send Mail Task, it uses the above connection. The To: , From: , Subject fields are populated. Message SourceType is DirectInput, MessageSource is Test, Priority is Normal and no attachments or expressions etc.

Nothing useful is logged in the Event Viewer even with full logging turned on.

Any suggestions appreciated,

Thanks.









View 11 Replies View Related

Configure SMTP Server Mail To Send Mail

Feb 10, 2008

Hello,
The Database Mail feature is already enabled on the server, also I have a mail account on the other server.
The problem I faced is that I need to send mail from my SQL Server using a created email account on the other server. How should I configure my email to do that ?
Should I use a sysmail_add_account procedure to enable account, also set profile and profile account ? Does this way creates server mail account that is binded with other email account?
The mail should be sent from my SQL Server.
Thank You.

View 3 Replies View Related

Error Sending Mail With Send Mail Task

Feb 6, 2008

I keep getting a generic "Error Sending Mail" error. For testing purposes I am just trying to send using my own email account. What goes in the SMTP Server box in the connection manager? I have tried:

A - the exchange server address (SOMETHING.us.company.com)
B - The SMTP properties I see when I look at the properties of my email address: (my.name@abcd.efgh.company.com)
C - Just the end portion of the SMTP properties: (abcd.efgh.company.com)
D - My email address (my.name@company.com)

I don't know what to enter, or what is giving me such a generic error message.

View 7 Replies View Related

Help With Mail That Send Mail When Database Bakcup Fails

Sep 1, 2006

Hello

I have got a script which gives the mail to the dba mail box when database backup fails.

In the script I want to make a change so that I get the particular database name , on what ever database i implement.

Can you tell me some suggestions.

The script I am using is :



use master
go
alter PROCEDURE dbo.SendMail
@to VARCHAR(255),
@subject VARCHAR(255),
@message VARCHAR(8000)
AS
BEGIN
SET NOCOUNT ON;
DECLARE
@rv INT,
@from VARCHAR(64),
@server VARCHAR(255);
SELECT
@from = 'testsql2000@is.depaul.edu',
@server = 'smtp.depaul.edu';


select @message = @message + char(13) + Char(13) + @@servername + '-'+ db_name()+ '-' + 'Backup Status Failed' + Char(13)

EXEC @rv = dbo.xp_smtp_sendmail
@to = @to,
@from = @from,
@message = @message,
@subject = @subject,
@server = @server;
END
GO




--- After the above script is run the following should be given in the 2nd step when
--- the backup jobs are scheduled ------

exec master.dbo.sendmail
@to = 'dvaddi@depaul.edu',
@subject =' Test sqlserver 2000',
@message = '' ;




Thanks

View 4 Replies View Related

Sending Mail To Several Users With Send Mail Task ?

Nov 10, 2006

I know you can specify additional recipients in the To column by sepperating them with a semicolon. But whats the easiest way to send to several users, when the email address must be retrieved from a table with a query like this:

select email from problem_subscribers

where project = 'project1'

and statusmail = 'OnError'

So when the eventhandler gets an OnError i want the mail task to be sent to each problemsubscriber.



View 3 Replies View Related

Unable To Send Test Mail From DB Mail

Jul 29, 2013

NOT ABLE TO SEND TEST MAIL FROM DB MAIL...The mail could not be sent to the recipients because of the mail server failure. . Exception Message: Cannot send mails to mail server. (Failure sending mail.).Exception Message: Cannot send mails to mail server. (Failure sending mail.).

View 4 Replies View Related

Permission To Send Mail Mail From Dts

Oct 2, 2002

hello everybody.

I have server server1
sql server and agent and mail profiler
running using mydomainsvcsql

dts (test_dts)created by user domainalex
with "use windows athentication"

dts steps
1. exe sp_who2
2. send mail to joe



user domainjoe run
DTSRun /S server1 /E /N test_dts
with error
Error: -2147220352 (80040480); Provider Error: 0 (0) Error string: Logon failed: MapiLogonEx Failed due to MAPI error 273: MAPI Logon failed

what permisissions should be granted to
domainjoe
in order to run dts from DTSRun ?


Thank you

View 4 Replies View Related

Not Able To Send Test Mail From DB Mail

Jul 29, 2013

NOT ABLE TO SEND TEST MAIL FROM DB MAIL///The mail could not be sent to the recipients because of the mail server failure. . Exception Message: Cannot send mails to mail server. (Failure sending mail.).Exception Message: Cannot send mails to mail server. (Failure sending mail.).

View 3 Replies View Related

Integration Services :: Send Excel File From SSIS Using Send Mail Task Without Saving Excel File Locally?

Jul 14, 2015

Is there anyway to  send excel file from ssis using send mail task without saving the excel file locally. I need to automate the process which involves loading the excel file from the database and send it to some people. 

View 6 Replies View Related

HELP! - Can't Send Mail

Jul 20, 2005

xp_sendmail has died on our SQL Server, I get error "xp_sendmail:failed with mail error 0x80004005" if I try using it.I believe that the reason that this has happened is because the SQLServer service account is unable to send mail, as follows:If I log on to Outlook Web Access as the SQL Server service account(SVC_SqlServer) I am able to receive mail. However, any mail sent fromthis account simply dissapears.It appears in the Sent items folder (in OWA for the SVC_SqlServeraccount) but the recipient (me, in this case) never receives it!Does anyone know why this account is unable to send mail?Help!eddiec :-)

View 1 Replies View Related

Send Mail Help

Jan 3, 2007

Hi,

How can I Send Mail with the query result having multiple rows. What type of dataflow destination is correct (recordset, datareader). The Send Mail task is working correctly. But, the message is blank without any result set.

Appreciate your help.

Thanks

View 16 Replies View Related

Send Mail

Aug 20, 2007



hi friends

1) sql connection SMTP Connection Manager 1 (windows authenditacaion/smtp both itried i was selected)
2) from/to /cc : i entered som mail ids of yahoo
3) subject : Hi koti how r u ,i am fine here

4) message source type : variable
SMTPSERVER: it is just string with null value i was declare a variable
ok fine then



how to use the send mail in the foreach loop example please send me

regards
koti

View 1 Replies View Related

How To Send Mail Through SQL Server...

Oct 6, 2004

Hi,

I have a requirement of sending mail through SQL Server through SMTP port... But, I dont want to configure my database server as e-mail client...

Is there any way to do it...

Thanks in advance...

View 5 Replies View Related

Send Mail Task

Oct 18, 2004

We have jobs running successfully on one server. The jobs incluce a send mail step as one of the steps. We migrated the DB to a new server. I also migrated the jobs. Now the job is failing. We are getting error with the send mail task.
The error says the stored procedure 'master.dbo.xp_smtp_sendmail' could not be found. I am not sure what is the problem. Please advise.

Thanks
Radhika

View 4 Replies View Related

Send Mail Sql Server2005

Apr 29, 2008

hi
how to send mail in sql server2005

View 1 Replies View Related

Send Mail From Sqlserver

Jun 3, 2008

Hi all
I want to send a mail from sqlserver2005.
could you help me out

View 2 Replies View Related

How Can I Send Mail By Using Sql Server

Aug 24, 2007

hi allmy query is how can i send mail by using sql server, i think by unsingxp_sendmail store procedure we can do this but my problem is whatparamater to be pass to this store procedure if i want to send mailfrom my local machine to another user, bcos i am geeting this errormsg in query analyzer...query:-EXEC master..xp_sendmail 'ss35934' (ss35934 is valid user namepresent into my local nerwork)getting error msg :- xp_sendmail: failed with mail error 0x80040111from:- sachin shah

View 3 Replies View Related

Send E-Mail TO SQL Server

Jul 20, 2005

I have a SQL Server 2000 application that send's e-mail to users usingthe xp_smtp_sendmail procedure. That works fine. What I would liketo do is RECIEVE e-mail with SQL Server.Example: I text message an alert to a user. They reply with somekeyword in the subject of their reply e-mail, such as 'ACKNOWLEDGED'or 'ACK' for short. SQL Server recieves this and then acts upon itwith a stored procedure, etc.Anyone know if this is possible and with what tool?TIA,Lindsey

View 3 Replies View Related

Send Mail Task

Jun 22, 2005

hi.

View 9 Replies View Related

Send E-mail For Each Row In Data Set

Jul 13, 2007

I need to send an email for each row in a dataset. The data set will contain the order number. I need to first look up the order detail based on the order number and put it into an e-mail. Should I use the OLE DB command object for this?

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved