BCP IN getting failed in SQL SERVER 2008
While trying to BCP IN from text to table, I am facing below mentioned error:
Starting copy...
SQLState = 22005, NativeError = 0
Error = [Microsoft][SQL Server Native Client 10.0]Invalid character value
for cast specification
SQLState = S1000, NativeError = 0
Error = [Microsoft][SQL Server Native Client 10.0]Unexpected EOF
encountered in BCP data-file
0 rows copied.
Network packet size (bytes): 4096
Clock Time (ms.) Total : 47
Format file: Please find the format file here
Input File: Please find the input file here
Table Structure:
CREATE TABLE [dbo].[Insert_record_mpr](
[RPT_DT] [date] NOT NULL,
[RECORD_TYPE] [char](1) NOT NULL,
[MCO_CONTRACT] [char](5) NOT NULL,
[PBP_ID] [char](3) NOT NULL,
[PLAN_SEGMENT_ID] [char](3) NOT NULL,
[HICN] [char](12) NOT NULL,
[LAST_NAME] [char](7) NOT NULL,
[FIRST_INITIAL] [char](1) NOT NULL,
[SEX] [char](1) NOT NULL,
[BIRTH_DT] [date] NOT NULL,
[PAYMENT_OPTION] [char](3) NOT NULL,
[FILLER1] [char](1) NOT NULL,
[PERIOD_START_DT] [date] NOT NULL,
[PERIOD_END_DT] [date] NOT NULL,
[NUMBER_OF_MONTHS] [int] NOT NULL,
[PARTC_PREMIUMS] [money] NOT NULL,
[PARTD_PREMIUMS] [money] NOT NULL,
[PARTD_LEP] [money] NOT NULL,
[FILLER2] [char](80) NOT NULL,
[PRCS_STS] [char](5) NULL,
[TOTAL_PREMIUM] [money] NULL,
[PREMIUM_PER_MONTH] [money] NULL
) ON [PRIMARY]
No comments:
Post a Comment