Solved

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

Posted on 2013-05-19
2
1,195 Views
Last Modified: 2016-02-10
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
Comment
Question by:Mark B
2 Comments
 
LVL 8

Accepted Solution

by:
jpgobert earned 500 total points
ID: 39180162
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
 

Author Closing Comment

by:Mark B
ID: 39199818
thanks, this helped.
0

Featured Post

Complete Microsoft Windows PC® & Mac Backup

Backup and recovery solutions to protect all your PCs & Mac– on-premises or in remote locations. Acronis backs up entire PC or Mac with patented reliable disk imaging technology and you will be able to restore workstations to a new, dissimilar hardware in minutes.

Join & Write a Comment

Suggested Solutions

In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
My client sends data in an Excel file to me to load them into Staging database. The file contains many sheets that they have same structure. In this article, I would like to share the simple way to load data of multiple sheets by using SSIS.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties

758 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now