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 - 2003-01-17 : 08:43:43
|
| brian writes "I have a table that I need to export to a text file but I can only write 2000 records per file. Each text file that is generated requires the suffix to be incremented to the next alphabetical letter. For example, if I exported 2400 records, a file named 20020113_A.txt would contain 2000 records and a file named 20020113_B.txt would contain the last 400 records. Is there a way in DTS to export to multiple files?Thanks,Brian" |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-01-17 : 08:56:34
|
| Yes - but do you need to use dts?It's a lot more complicated than bcp for instance.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
Export to text file with record limit...