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 |
|
cronid
Starting Member
26 Posts |
 Posted - 2006-09-11 : 13:29:03
|
| I have a number of queries I wish to include in one package, writing to one document which I will send in an email. When I put the queires in the DTS source only the first query is executed.How can i execute multiple queires in the one source? |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-09-12 : 02:44:28
|
| use workflow inside the dts designer HTH--------------------keeping it simple... |
 |
|
|
cronid
Starting Member
26 Posts |
Posted - 2006-09-12 : 15:09:10
|
| I don't see how workflow helps. If i create 5 separate queries in five separate steps I'd need to write to five separate text destinations. I want to write to just one. But I don't see that you can append results to a text destination. It seems as if it should be easy but I'm unable to find any examples or discussions on how to accomplish this task. |
|
|
|
|
|
|
multiple queries