Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SSIS and Import/Export (2008)
 SSIS E-Mail an Excel

Author  Topic 

denis_the_thief
Aged Yak Warrior

596 Posts

Posted - 2011-10-05 : 11:48:50
Very open ended question here. I'm new to SSIS. I want to run a query, dump the results to Excel or csv then E-Mail the files.

Anyone have any tips or recommend a good link?

I am just not sure where to start... Except the scheduling part, I think I know how to schedule the SSIS Package at least.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-10-05 : 12:04:16
you can use send mail task for that.

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

denis_the_thief
Aged Yak Warrior

596 Posts

Posted - 2011-10-05 : 13:52:15
OK, cool.
Go to Top of Page
   

- Advertisement -