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 - 2006-04-11 : 09:25:49
|
| Brandon writes "I was wondering if it's possible to export multiple query's data to varying text files, without the use of dts or bcp? The problem is I don't have permissions to the xp_cmdshell, and the information i want to export would be coming from a temporary variable table, not a temp table, which rules out dts (as I understand it). I am trying to reduce the number of processes a task takes, and the only thing left is to export a variable number of queries to a like number of files. I however, want to alleviate human interaction to ensure all information is processed, so I don't want the user to select the query result and select save. I need this to be a scripted means.If you could help me on this I would much appreciate it.Thank you,Brandon." |
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2006-04-12 : 02:57:24
|
| Should be able to do that in DTS. Can you POST the code?------------------------I think, therefore I am - Rene Descartes |
 |
|
|
|
|
|
EXPORT MULTI QUERY DATA TO TEXT FILE