How to schedule email excel file using ssis package and sql server agent

Hi, I have created a file system ssis package by using the export data wizard on out MS SQL 2008 R2 server. This ssis package's destination is an xls file on the file system.

Questions:

1. everytime I run the ssis package, will the results write over the previous results? If not, how to I make sure the xls file is only the results from the last time the ssis package was engaged?

2. I want to schedule a sql server agent job that will run this ssis package and email the xls file. How to do this?

I understand how to set a step in a sql server agent job for the ssis package and how to schedule the job, but I am not sure how to email the xls file in sql server agent.

I am not a sql server expert- any input would be great.
Mark BDirector ITAsked:
Who is Participating?
 
jpgobertConnect With a Mentor Enterprise IT Systems ConsultantCommented:
Hi,

I'm assuming you're working with SQL Server 2008 since that's where you posted this... if not, let me know and I'll reply with any differences.

Basically you can setup database mail in SQL.  Once setup it's really easy to send email from within SQL.

Check out the step by step guide posted here:  Code Project - Configure Database Mail in SQL 2008

Since you're already familiar with building agent jobs and such you shouldn't have any problem following the guide at that link.
0
 
Mark BDirector ITAuthor Commented:
thanks, this helped.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.