January 4, 2002 at 1:59 pm
My question is does the FORMAT file have a specific format or structure, I specifically want to know what colums the different variables go into. I can not run BCP to create the format file, That is a DBA function here, but I am responsible for building it. I would like to know what columns to put the fields in.
William H. Hoover
Louisville, Ky
sweeper_bill@yahoo.com
January 4, 2002 at 2:44 pm
Here's a link that describes the structure of the format file. If you have Books Online installed on your system, it's the same as:
Index tab >> bcp utility >> format files
K. Brian Kelley
http://www.sqlservercentral.com/columnists/bkelley/
K. Brian Kelley
@kbriankelley
January 4, 2002 at 5:10 pm
January 4, 2002 at 6:26 pm
Oops. Thanks for the save, Steve.
K. Brian Kelley
http://www.sqlservercentral.com/columnists/bkelley/
K. Brian Kelley
@kbriankelley
January 7, 2002 at 11:50 am
Yes, Thanks to all, I have that information, my question is does it matter what columns these fields go into. Can I create a BCP format file without running the BCP command first.
ig. What column does the Version go into?
What column does the Prefix Length go into? etc.
Again thanks,
William H. Hoover
Louisville, Ky
sweeper_bill@yahoo.com
January 7, 2002 at 1:48 pm
It specifies the specific columns. follow the format listed exactly. On the verson line it is the first column.
Steve Jones
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply