Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 Send email of the staus of the package

Author  Topic 

jim_jim
Constraint Violating Yak Guru

306 Posts

Posted - 2010-08-27 : 10:24:04
Can someone help me how to setup my ssis package to send an email of the status of the package once it runs

I have created a very simplae package to generate a flat file from a sql servr database usinf data conversion transformation

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-08-27 : 13:29:14
Add an email task to your package and have it run on completion of the export.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

jim_jim
Constraint Violating Yak Guru

306 Posts

Posted - 2010-08-27 : 14:42:17
I have added an sendmail task to the control flow
can you advise how do i configure the sendmail task to only run when the other package has executed succesfully
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2010-08-28 : 02:23:46
you can add it in same package after on success completion of your other tasks

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page
   

- Advertisement -