Question about BCP

What is the use of BCPFILEFMT bcp_control option? What value can be provided with this option?

I was wondering whether this option could be used to specify data-file format (-n/-c/-N) as in bcp command line option.

DM

Hi,

BCPFILEFMT is used to specify the version of the format file, which will trigger the corresponding parser behavior. In general, this option is for internal use. Unfortunately it cannot be used to specify native vs. character type data file format. Instead, the data file format is implied by the way you describe the columns using bcp_colfmt, etc.

HTH,
Jivko Dobrev - MSFT
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

Thanks for the reply.

One thing i've found during testing is that bcp_control accepts following values for the BCPFILEFMT option.

- 60/65/70/80 - which i think is the sql server data-format specification.