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 |
|
DaveBF
Yak Posting Veteran
89 Posts |
 Posted - 2010-09-15 : 13:25:23
|
| Hi,I'm having a hard time finding information on how to create an XML Format File for importing a flat file with fixed length fields, into SQL using Bulk Copy. I see some info on comma-delimited fields. Can someone point me to an introduction to Bulk Copy and how to set up and use the Format File? I don't really care whether it's XML or not but I have fixed length fields in my source text file and I heard Bulk Copy is the way to go.Thanks. |
|
|
|
|
|
Bulk Copy format file