Solved

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

Posted on 2013-05-19
2
1,202 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

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Here's a requirements document template for an integration project (also known as Extract-Transform-Load or ETL) based on my development experience as an SQL Server Information Services (SSIS) developer over the years.
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

911 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

23 Experts available now in Live!

Get 1:1 Help Now