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.
| Author |
Topic |
|
Topaz
Posting Yak Master
199 Posts |
 Posted - 2010-06-24 : 10:10:04
|
| I have a huge SQL database that is used for email marketing purposes. It records, openemails, clickthrus and which batch they were sent in.At the moment after I send out an email campaign (a batch) I run a SQL query to find out how many clickers and opened emails were generated and then enter the information into an Excel spreadsheet for further analysis. Is there anyway I can get SQL to run the query and then fill out an Excel for me automatically?JT |
|
|
slimt_slimt
Aged Yak Warrior
746 Posts |
Posted - 2010-06-24 : 15:14:54
|
| You can do this in SSIS as Integration services in Sql Server.please post an example. |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2010-06-25 : 03:32:42
|
| http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=49926MadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
SQL auto updating an Excel spreadsheet