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 |
|
wylderubicon
Starting Member
10 Posts |
 Posted - 2008-03-24 : 17:06:26
|
| I sql server 2005, I need to export to a fixed width text file.I can do this using import/export wizard, but my output file does not a CR/LF or end of record marker. There is no option to add this. my main reason for using the wizard is because I need to export the file without unicodes, and I can't seam to find any other way. any options?thanks!Alan |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-24 : 22:27:55
|
| Tried with bcp? |
 |
|
|
wylderubicon
Starting Member
10 Posts |
Posted - 2008-03-25 : 10:07:07
|
| what is bcp? sorry, I'm still fairly new to sql.thanks |
|
|
|
wylderubicon
Starting Member
10 Posts |
Posted - 2008-03-25 : 11:18:55
|
| any other way to do this? I would ideally like to use "SELECT" but I can't select to a flat text file, Am I missing something is the settings?thanksAlan |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-03-25 : 14:26:37
|
| Try bcp with format file option. Look into BOL for sysntax. |
|
|
|
wylderubicon
Starting Member
10 Posts |
Posted - 2008-03-25 : 14:41:42
|
| Is there a good reference for how to get started with bcp? I've found some samples, but I don't even know where to begin. do I paste the comands in a new query? how do I open bcp? double clicking on bcp.exe does not do anything. thanks |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-03-25 : 14:54:27
|
| http://msdn2.microsoft.com/en-us/library/ms162802.aspx |
|
|
|
|
|
|
exportting to a flat text file