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 - 2001-12-31 : 09:53:33
|
| Scott writes "Recently I was asked to create a set of up to 1000 text files from the data contained in a table. The contents of each output file is determined by the Product Family ID which also determines the file name as well.This was easy to construct using BCP in a cursor; yet I am limited by the functionality of this tool, and would really prefer a DTS solution.How can a DTS workflow be run in a loop like my cursor (eek!) solution?The cursor performs the following logic which might shed some light:Get a distinct list of all Product Family ID's.In the cursor, get all records for an ID and create the output file with the proper name.Execute this process until all Product Family ID's are handled.Note: The Product Family ID's always change and cannot be anticipated before the execution.BCP solution took me 15 minutes. I'm curious as to the DTS solution.Thanks in advance." |
|
|
|
|
|
Using DTS to Create a Dynamic Set of Text Files