Search code examples
emailssistasksend

scheduled send mail task in SSIS

I have created a package in SSIS to fetch data from SQL Server table, then stored the result into an Excel destinationand and created a send email task .

How can i schedule the package to run automatically ? for example , every sunday at 11am ?

Solution

  • Save it out and run it in a sql job, then schedule the job for the day(s) and time(s) you need.