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 |
|
Trudye
Posting Yak Master
169 Posts |
 Posted - 2008-09-03 : 14:17:08
|
| Hi Guys, I am trying to export a fixed file. I tried changing the format to “Fixed Width”. However when the file is exported the end of row is not detected. The value in the Header row delimiter field is {CR}{LF}. The file was created in a SQL Server proc. It is defined as:Field1 Varchar (6)Filler Varchar (1)Field2 Varchar (5)Any ideas on how can I get the file to export properly?Thank you,Trudye |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-09-04 : 02:30:29
|
| try using bcp or BULK INSERT after specifying a format file.refer below for more detailswww.nigelrivett.net/SQLTsql/ BCP_quoted_CSV_Format_file.html |
 |
|
|
|
|
|
Exporting a Fixed file