Re: [Skunkworks] BCP utility in SQL Server

On 3/17/10, Mr. Lawi <mail2lawi@gmail.com> wrote:

Hi guys,

bcp.exe dbname.db_user.cust_table out c:\bcp\reports\report.txt -f cust.fmt -S MSSQL -U db_user -P db_user -c

I get this error/warning:

"-c override -f"

The cust.fmt file is as below:

1 SQLCHAR 0 10 "\t" 1 Name 2 SQLCHAR 0 16 "\t" 2 Cust_ID 3 SQLCHAR 0 10 "\t" 3 Town 4 SQLCHAR 0 10 "\t" 4 ClassCode 5 SQLCHAR 0 10 "\t" 5 DescCode 6 SQLCHAR 0 80 "\t" 6 Term Description 7 SQLCHAR 0 16 "\t" 7 AccountNumber 8 SQLCHAR 0 10 "\t" 8 Status 9 SQLCHAR 0 10 "\t" 9 Date 10 SQLCHAR 0 10 "\t" 10 OpeningDate 11 SQLCHAR 0 10 "\t\n" 11 MaturityDate

Thnx