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 |
|
gemispence
Yak Posting Veteran
71 Posts |
 Posted - 2006-03-06 : 10:20:35
|
| I'm using DTS to export a table. I need each record to be on a separate line, but I have a description field that is quite lengthy so it's not fitting on one line. Can someone advise how to accomplish each record being on only one line? :) |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-03-06 : 14:25:48
|
| How do you know that they are on multiple lines? Via notepad? Word wrap is turned on?Tara Kizeraka tduggan |
 |
|
|
gemispence
Yak Posting Veteran
71 Posts |
Posted - 2006-03-06 : 16:49:24
|
| using notepad. Word wrap turned off. I believe that it's a Notepad issue b/c I'm using Carriage return on export. |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2006-03-06 : 17:20:07
|
| You should get a file viewer application that lets you look at exactly what you have in your output file.This one works well for me; it's not free, but you can try it for a while before you buy.http://www.fileviewer.comCODO ERGO SUM |
|
|
|
|
|
|
Exporting Records to Text