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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-07-15 : 10:30:51
|
| David writes "I would like to create a DTS Package that does the following:Check a SQL statement for Record CountIf the count is >0, run a DTS package to export a view to excel.If the count is = 0, run a different DTS package such as an email stating there are no records to export.I've created the SQL statement to check the record count.I've created the DTS to export a view to excel.I've created the email.Just can't figure out how to put it all together. " |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2004-07-15 : 12:41:51
|
| solving DTS design problems in these forums is somewhat difficult because DTS is so visual.My suggestion is to check out www.sqldts.com and read their articles to see if they can help. You might also want to pick up a book on DTS at amazon.com. Although there aren't any really excellent books on DTS, the one from Wrox press is decent.-ec |
 |
|
|
ctms
Starting Member
1 Post |
Posted - 2004-07-15 : 20:25:18
|
| Thank you for your input ec, I've been to the sites and got the book(s) (SQL Server DTS by New Riders), and while it had some real life workflow scenarios, there was not much there to assist me in my endeavor. I've since managed to figure it out on my own. Just had to take a step back and look at the big picture, then I was able to put it all together. |
|
|
|
|
|
|
Help Creating DTS