Notify Operator Task -- no database mail profile option

Hi.
I'm trying to add a notify operator task to a SSIS package, and I don't want the task to use the default mail profile.

It seems I cannot specify a profile name on an operator or a NotifyOperator task... I can work around it by just executing sql ('sp_notify_operator @profile_name'), but I want to use the task, it's just SOO PRETTY!!! ;)

Thanks!

[386 byte] By [PugV] at [2007-12-16]

SQL Server

Site Classified