bcp command:

"C:\PROGRAM FILES\MIcrosoft SQL Server\80\Tools\Binn\bcp" ie_master.dbo.D_BillTypes out Y:\bcptest\D_BillTypes.txt -S******** -Uds_user -P******* -fY:\bcptest\D_BillTypes.fmt

table definition:

USE ie_master

go

CREATE TABLE dbo.D_BillType

(

BTC_BILL_TYPE_CODE char(3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

BTC_BILL_TYPE_DESCRIPTION char(20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

BTC_EXPIRY_DATE datetime NULL,

int NOT NULL,

CONSTRAINT PK_D_BillType

PRIMARY KEY NONCLUSTERED ()

WITH FILLFACTOR=90 ON IndexFileGroup

)

ON IndexFileGroup

go

IF OBJECT_ID(N'dbo.D_BillType') IS NOT NULL

PRINT N'<<< CREATED TABLE dbo.D_BillType >>>'

ELSE

PRINT N'<<< FAILED CREATING TABLE dbo.D_BillType >>>'

go

.fmt definition

8.0

4

1 SQLCHAR 0 3 "~" 1 BTC_BILL_TYPE_CODE SQL_Latin1_General_CP1_CI_AS

2 SQLCHAR 0 20 "~" 2 BTC_BILL_TYPE_DESCRIPTION SQL_Latin1_General_CP1_CI_AS

3 SQLCHAR 0 26 "~" 3 BTC_EXPIRY_DATE ""

4 SQLINT 0 4 "\r" 4 key ""

cheers

john