Forum Replies Created

Viewing post 1 (of 1 total)

  • RE: SSIS - send mail task

    if you are using dbmail get your dba to give you DatabaseMailUserRole permisisons

    use a sql execute task with a command like this:

    EXEC msdb.dbo.sp_send_dbmail @profile_name="profile_name_here",

    @recipients='your_name@your_company.com',

    @subject='Test message',

    @body=' dont panic yet'

    it...

Viewing post 1 (of 1 total)