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 |
|
mayerl
Yak Posting Veteran
95 Posts |
 Posted - 2010-07-01 : 11:41:25
|
| Morning,Is there a way to export text files in a specific format? For example I have to send a file to corporate and they require a header record, data starting at position 1 length 3, ect, ect, trailer record. I did this in oracle before but never had a reason to do this in SQL. Can someone direct me to the right resource? ThanksLaura |
|
|
yosiasz
Master Smack Fu Yak Hacker
1635 Posts |
Posted - 2010-07-01 : 12:14:49
|
| bcp is your friend.<><><><><><><><><><><><><><><><><><><><><><><><><>If you don't have the passion to help people, you have no passion |
 |
|
|
mayerl
Yak Posting Veteran
95 Posts |
Posted - 2010-07-01 : 14:06:06
|
| Thanks for that. I'll see if I can use it. |
|
|
|
|
|
|
way to export text files in a specific format?