Mark B
asked on
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER