dbaspot
Tags Register FAQ Calendar Search Today's Posts Mark Forums Read

SSIS access to database mail from "Notify Operator" task - sqlserver-dts

This is a discussion on SSIS access to database mail from "Notify Operator" task - sqlserver-dts ; I have successfully configured and tested database mail on a sql server 2005 instance. When I attempt to create an SSIS "Notify Operator" task pointing to a connection definition for the sql server 2005 instance, I receive the following error ...


Home > Database Forum > Microsoft SQL Server > sqlserver-dts > SSIS access to database mail from "Notify Operator" task

Reply

 

LinkBack Thread Tools Display Modes
  #1  
Old 07-10-2006, 04:36 PM
Database Bot
 
Join Date: Sep 2009
Posts: 1,236,254
Database Administrator is on a distinguished road
Default SSIS access to database mail from "Notify Operator" task

I have successfully configured and tested database mail on a sql server 2005
instance. When I attempt to create an SSIS "Notify Operator" task pointing to
a connection definition for the sql server 2005 instance, I receive the
following error message:

"This task requires the mdsb database to be configured as a database mail
host."

I am assuming that the "mdsb" in the message is a typo and should read
"msdb". Does anyone have any ideas what would be causing this?

Thank you.

Reply With Quote
  #2  
Old 07-31-2009, 05:15 PM
Database Newbie
 
Join Date: Jul 2009
Posts: 1
tkeme402 is on a distinguished road
Default Re: SSIS access to database mail from "Notify Operator" task

Hi did you ever get a response to this? I am receiving the same error message.

Thanks,

TKE402
Reply With Quote
Reply

Thread Tools
Display Modes



All times are GMT -4. The time now is 10:37 PM.