• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1330
  • Last Modified:

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.
0
Mark B
Asked:
Mark B
1 Solution
 
jpgobertCommented:
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

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now