Maria Torres
asked on
Unable to execut BULK INSERT due to format file issue
I created a format file, via BCP. When I try to load the data using the format file, I get the following message:
==========================
(0 row(s) affected)
Msg 4862, Level 16, State 1, Line 6
Cannot bulk load because the file "S:\CARMEN\fmtEspd.fmt" is incomplete or could not be read. Operating system error code (null).
==========================
I then modified the format file to only contain one record (column), to see if I can at least populate one field; I still get the above error.
My format file is as follows:
My script file that performs the bulk insert is as follows:
Would someone know how to resolve this error or what I am doing wrong? Also, what does this message mean?
Thank you in advance.
==========================
(0 row(s) affected)
Msg 4862, Level 16, State 1, Line 6
Cannot bulk load because the file "S:\CARMEN\fmtEspd.fmt" is incomplete or could not be read. Operating system error code (null).
==========================
I then modified the format file to only contain one record (column), to see if I can at least populate one field; I still get the above error.
My format file is as follows:
12.0
1
1 SQLCHAR 1 5 "~" 1 CNVRSN_SRC_CD SQL_Latin1_General_CP1_CI_ASMy script file that performs the bulk insert is as follows:
USE HCDA;
GO
DELETE dbo.ST_NJ_EPSD_16;
GO
BULK INSERT dbo.ST_NJ_EPSD_16
FROM 'S:\CARMEN\stnjep16.dat'
WITH (FORMATFILE ='S:\CARMEN\fmtEspd.fmt');
GO
SELECT * FROM dbo.ST_NJ_EPSD_16;
GO Would someone know how to resolve this error or what I am doing wrong? Also, what does this message mean?
Thank you in advance.
ASKER
My syntax was incorrect. I omitted the key word "IN".
I was able to proceed further with my import but encountered another error. I'm now getting the following message:
=======================
SQLState = 22001, NativeError = 0
Error = [Microsoft][ODBC Driver 11 for SQL Server]String data, right truncation
=======================
I'm running the bcp command at the command prompt window. Is there a way of instructing bcp to display the field that is being right truncated. (My dat file contains over 400,000 records; and this error message is displayed for every 50,000 records.)
Thank you in advance.
I was able to proceed further with my import but encountered another error. I'm now getting the following message:
=======================
SQLState = 22001, NativeError = 0
Error = [Microsoft][ODBC Driver 11 for SQL Server]String data, right truncation
=======================
I'm running the bcp command at the command prompt window. Is there a way of instructing bcp to display the field that is being right truncated. (My dat file contains over 400,000 records; and this error message is displayed for every 50,000 records.)
Thank you in advance.
Unfortunately without parsing thru the data you cant see which value caused the issue.
You can alter the column size and the update the format file before you run the BULK INSERT Statement and investigate the values afterwards
Also Instead of the statement DELETE dbo.ST_NJ_EPSD_16; use truncate statement
You can alter the column size and the update the format file before you run the BULK INSERT Statement and investigate the values afterwards
Also Instead of the statement DELETE dbo.ST_NJ_EPSD_16; use truncate statement
ASKER
How do I go about determining which column to alter its size? The error message does not indicate which column (field) is causing the problem.
Your format file shows only 1 field CNVRSN_SRC_CD
ASKER
Sorry, wrong format file. The following is my format file:
12.0
215
1 SQLCHAR 0 5 "~" 1 CNVRSN_SRC_CD SQL_Latin1_General_CP1_CI_AS
2 SQLCHAR 0 41 "~" 2 LHS_REC_NUM ""
3 SQLCHAR 0 30 "~" 3 RCV_DT ""
4 SQLCHAR 0 30 "~" 4 EPSD_1ST_PD_DT ""
5 SQLCHAR 0 30 "~" 5 EPSD_LAST_PD_DT ""
6 SQLCHAR 0 1 "~" 6 EPSD_SBTYPE_CD SQL_Latin1_General_CP1_CI_AS
7 SQLCHAR 0 6 "~" 7 MDCR_HOSP_ID SQL_Latin1_General_CP1_CI_AS
8 SQLCHAR 0 9 "~" 8 HOSP_ZIP_CD SQL_Latin1_General_CP1_CI_AS
9 SQLCHAR 0 2 "~" 9 HOSP_STATE_CD SQL_Latin1_General_CP1_CI_AS
10 SQLCHAR 0 4 "~" 10 HOSP_MSA_CD SQL_Latin1_General_CP1_CI_AS
11 SQLCHAR 0 30 "~" 11 ADMSN_DT ""
12 SQLCHAR 0 1 "~" 12 ADMSN_QTR SQL_Latin1_General_CP1_CI_AS
13 SQLCHAR 0 1 "~" 13 ADMSN_DAY SQL_Latin1_General_CP1_CI_AS
14 SQLCHAR 0 30 "~" 14 DSCHRG_DT ""
15 SQLCHAR 0 1 "~" 15 DSCHRG_QTR SQL_Latin1_General_CP1_CI_AS
16 SQLCHAR 0 2 "~" 16 DSCHRG_YR SQL_Latin1_General_CP1_CI_AS
17 SQLCHAR 0 1 "~" 17 ADMSN_TYPE SQL_Latin1_General_CP1_CI_AS
18 SQLCHAR 0 1 "~" 18 ADMSN_SRC SQL_Latin1_General_CP1_CI_AS
19 SQLCHAR 0 2 "~" 19 DSCHRG_DISP SQL_Latin1_General_CP1_CI_AS
20 SQLCHAR 0 1 "~" 20 BENE_VS_PRVDR_ST SQL_Latin1_General_CP1_CI_AS
21 SQLCHAR 0 15 "~" 21 PTNT_ID SQL_Latin1_General_CP1_CI_AS
22 SQLCHAR 0 41 "~" 22 PTNT_AGE ""
23 SQLCHAR 0 1 "~" 23 PTNT_SEX_CD SQL_Latin1_General_CP1_CI_AS
24 SQLCHAR 0 9 "~" 24 PTNT_ZIP_CD SQL_Latin1_General_CP1_CI_AS
25 SQLCHAR 0 2 "~" 25 PTNT_STATE_CD SQL_Latin1_General_CP1_CI_AS
26 SQLCHAR 0 4 "~" 26 PTNT_MSA_CD SQL_Latin1_General_CP1_CI_AS
27 SQLCHAR 0 41 "~" 27 LOS ""
28 SQLCHAR 0 41 "~" 28 TOT_PD_AMT ""
29 SQLCHAR 0 41 "~" 29 TOT_CHRG_AMT ""
30 SQLCHAR 0 41 "~" 30 TOT_CST_AMT ""
31 SQLCHAR 0 41 "~" 31 DAY_PRCDR ""
32 SQLCHAR 0 1 "~" 32 PRNCPL_PYR_GRP SQL_Latin1_General_CP1_CI_AS
33 SQLCHAR 0 16 "~" 33 PHYSN_OPRTNG_1_ID SQL_Latin1_General_CP1_CI_AS
34 SQLCHAR 0 16 "~" 34 PHYSN_OPRTNG_2_ID SQL_Latin1_General_CP1_CI_AS
35 SQLCHAR 0 16 "~" 35 PHYSN_ATNDG_ID SQL_Latin1_General_CP1_CI_AS
36 SQLCHAR 0 16 "~" 36 PHYSN_ADMTG_ID SQL_Latin1_General_CP1_CI_AS
37 SQLCHAR 0 16 "~" 37 PHYSN_OTHR_ID SQL_Latin1_General_CP1_CI_AS
38 SQLCHAR 0 16 "~" 38 PHYSN_RSPNSBL_ID SQL_Latin1_General_CP1_CI_AS
39 SQLCHAR 0 2 "~" 39 MDC_CD SQL_Latin1_General_CP1_CI_AS
40 SQLCHAR 0 1 "~" 40 MDCL_SRGRY_SW SQL_Latin1_General_CP1_CI_AS
41 SQLCHAR 0 3 "~" 41 DRG_CD SQL_Latin1_General_CP1_CI_AS
42 SQLCHAR 0 3 "~" 42 ADRG_CD SQL_Latin1_General_CP1_CI_AS
43 SQLCHAR 0 4 "~" 43 REFN_DRG_CD SQL_Latin1_General_CP1_CI_AS
44 SQLCHAR 0 1 "~" 44 REGRP_DRG483_SW SQL_Latin1_General_CP1_CI_AS
45 SQLCHAR 0 1 "~" 45 OUTCM_CLS_CD SQL_Latin1_General_CP1_CI_AS
46 SQLCHAR 0 41 "~" 46 EXPCT_DEAD_PCT ""
47 SQLCHAR 0 41 "~" 47 EXPCT_PAC_PCT ""
48 SQLCHAR 0 41 "~" 48 EXPCT_QC_PCT ""
49 SQLCHAR 0 41 "~" 49 EXPCT_LOS_PCT ""
50 SQLCHAR 0 41 "~" 50 EXPCT_TOT_CHRG_AMT ""
51 SQLCHAR 0 41 "~" 51 EXPCT_TOT_CST_AMT ""
52 SQLCHAR 0 1 "~" 52 DSEASE_STAG_CD SQL_Latin1_General_CP1_CI_AS
53 SQLCHAR 0 41 "~" 53 BODY_SYS_CNT ""
54 SQLCHAR 0 1 "~" 54 PRNCPL_STAG_CD SQL_Latin1_General_CP1_CI_AS
55 SQLCHAR 0 1 "~" 55 SCNDRY_STAG_CD SQL_Latin1_General_CP1_CI_AS
56 SQLCHAR 0 1 "~" 56 RACE_CD SQL_Latin1_General_CP1_CI_AS
57 SQLCHAR 0 1 "~" 57 INSTNL_STAY_SRC_CD SQL_Latin1_General_CP1_CI_AS
58 SQLCHAR 0 2 "~" 58 AGE_RNG SQL_Latin1_General_CP1_CI_AS
59 SQLCHAR 0 1 "~" 59 DSCHRG_CLS SQL_Latin1_General_CP1_CI_AS
60 SQLCHAR 0 1 "~" 60 PPS_INDC SQL_Latin1_General_CP1_CI_AS
61 SQLCHAR 0 1 "~" 61 PRVDR_CD SQL_Latin1_General_CP1_CI_AS
62 SQLCHAR 0 2 "~" 62 ADMSN_YR SQL_Latin1_General_CP1_CI_AS
63 SQLCHAR 0 41 "~" 63 CVRD_DAYS ""
64 SQLCHAR 0 41 "~" 64 COINS_DAYS ""
65 SQLCHAR 0 41 "~" 65 LFTM_RSRV_DAYS ""
66 SQLCHAR 0 41 "~" 66 CVR_CHRG_AMT ""
67 SQLCHAR 0 41 "~" 67 REIMBRS_AMT ""
68 SQLCHAR 0 41 "~" 68 INTNSV_CARE_DAYS ""
69 SQLCHAR 0 41 "~" 69 CRNRY_CARE_DAYS ""
70 SQLCHAR 0 1 "~" 70 SRGRY_SW SQL_Latin1_General_CP1_CI_AS
71 SQLCHAR 0 41 "~" 71 BLOOD_FURNSH_CNT ""
72 SQLCHAR 0 3 "~" 72 CURRENT_DRG_CD SQL_Latin1_General_CP1_CI_AS
73 SQLCHAR 0 2 "~" 73 PTNT_MDCR_STUS_CD SQL_Latin1_General_CP1_CI_AS
74 SQLCHAR 0 3 "~" 74 PROP_DRG_CD SQL_Latin1_General_CP1_CI_AS
75 SQLCHAR 0 41 "~" 75 MRTLTY_DAYS ""
76 SQLCHAR 0 41 "~" 76 MDAN_AGE ""
77 SQLCHAR 0 5 "~" 77 FK_PTNT_EPSD_DACNV SQL_Latin1_General_CP1_CI_AS
78 SQLCHAR 0 3 "~" 78 FK_PTNT_EPSD_DALHS SQL_Latin1_General_CP1_CI_AS
79 SQLCHAR 0 30 "~" 79 FK_PTNT_EPSD_DARCV ""
80 SQLCHAR 0 41 "~" 80 VRNC_CST_AMT ""
81 SQLCHAR 0 41 "~" 81 VRNC_LOS ""
82 SQLCHAR 0 41 "~" 82 VRNC_CHRG_AMT ""
83 SQLCHAR 0 1 "~" 83 CMPLCATN_1_SW SQL_Latin1_General_CP1_CI_AS
84 SQLCHAR 0 1 "~" 84 CMPLCATN_2_SW SQL_Latin1_General_CP1_CI_AS
85 SQLCHAR 0 1 "~" 85 CMPLCATN_3_SW SQL_Latin1_General_CP1_CI_AS
86 SQLCHAR 0 1 "~" 86 CMPLCATN_4_SW SQL_Latin1_General_CP1_CI_AS
87 SQLCHAR 0 1 "~" 87 CMPLCATN_5_SW SQL_Latin1_General_CP1_CI_AS
88 SQLCHAR 0 1 "~" 88 CMPLCATN_TRCH_SW SQL_Latin1_General_CP1_CI_AS
89 SQLCHAR 0 41 "~" 89 DRCT_CST_AMT ""
90 SQLCHAR 0 41 "~" 90 ROUT_CST_AMT ""
91 SQLCHAR 0 41 "~" 91 SPCLTY_CST_AMT ""
92 SQLCHAR 0 41 "~" 92 ANCLRY_CST_AMT ""
93 SQLCHAR 0 41 "~" 93 ANCLRY_CHRG_AMT ""
94 SQLCHAR 0 41 "~" 94 PASS_THRU_AMT ""
95 SQLCHAR 0 41 "~" 95 ROUT_CHRG_AMT ""
96 SQLCHAR 0 41 "~" 96 SPCLTY_DAYS ""
97 SQLCHAR 0 41 "~" 97 SPCLTY_CHRG_AMT ""
98 SQLCHAR 0 30 "~" 98 PRCDR_DT ""
99 SQLCHAR 0 4 "~" 99 RSDNC_CD SQL_Latin1_General_CP1_CI_AS
100 SQLCHAR 0 1 "~" 100 V8_MDC_CD SQL_Latin1_General_CP1_CI_AS
101 SQLCHAR 0 1 "~" 101 V8_DRG_CD SQL_Latin1_General_CP1_CI_AS
102 SQLCHAR 0 41 "~" 102 SNF_ICF_DAYS ""
103 SQLCHAR 0 41 "~" 103 ACUTE_CARE_DAYS ""
104 SQLCHAR 0 41 "~" 104 RSDNTL_DAYS ""
105 SQLCHAR 0 9 "~" 105 MDCL_RCRD_ID SQL_Latin1_General_CP1_CI_AS
106 SQLCHAR 0 1 "~" 106 RDMSN_STUS SQL_Latin1_General_CP1_CI_AS
107 SQLCHAR 0 5 "~" 107 TRNSFR_CD SQL_Latin1_General_CP1_CI_AS
108 SQLCHAR 0 4 "~" 108 BILL_TYPE SQL_Latin1_General_CP1_CI_AS
109 SQLCHAR 0 3 "~" 109 PRMRY_PYR_CD SQL_Latin1_General_CP1_CI_AS
110 SQLCHAR 0 4 "~" 110 GRPR_TYPE SQL_Latin1_General_CP1_CI_AS
111 SQLCHAR 0 3 "~" 111 V9_DRG_CD SQL_Latin1_General_CP1_CI_AS
112 SQLCHAR 0 2 "~" 112 V9_MDC_CD SQL_Latin1_General_CP1_CI_AS
113 SQLCHAR 0 41 "~" 113 TOT_BILL ""
114 SQLCHAR 0 41 "~" 114 BILL_PRMRY ""
115 SQLCHAR 0 41 "~" 115 BILL_SCNDRY ""
116 SQLCHAR 0 41 "~" 116 BILL_TRTRY ""
117 SQLCHAR 0 41 "~" 117 BILL_PTNT ""
118 SQLCHAR 0 41 "~" 118 DUE_PRMRY ""
119 SQLCHAR 0 41 "~" 119 DUE_SCNDRY ""
120 SQLCHAR 0 41 "~" 120 DUE_TRTRY ""
121 SQLCHAR 0 41 "~" 121 DUE_PTNT ""
122 SQLCHAR 0 3 "~" 122 SCNDRY_PYR_CD SQL_Latin1_General_CP1_CI_AS
123 SQLCHAR 0 3 "~" 123 TRTRY_PYR_CD SQL_Latin1_General_CP1_CI_AS
124 SQLCHAR 0 1 "~" 124 DATA_TYPE SQL_Latin1_General_CP1_CI_AS
125 SQLCHAR 0 1 "~" 125 ONCLGY_FLAG SQL_Latin1_General_CP1_CI_AS
126 SQLCHAR 0 1 "~" 126 GYNCLGY_FLAG SQL_Latin1_General_CP1_CI_AS
127 SQLCHAR 0 1 "~" 127 CRDLGY_FLAG SQL_Latin1_General_CP1_CI_AS
128 SQLCHAR 0 1 "~" 128 NSI_SDS_FLAG SQL_Latin1_General_CP1_CI_AS
129 SQLCHAR 0 1 "~" 129 NJ_DOH_SDS SQL_Latin1_General_CP1_CI_AS
130 SQLCHAR 0 1 "~" 130 HOSP_SDS SQL_Latin1_General_CP1_CI_AS
131 SQLCHAR 0 1 "~" 131 ER_FLAG SQL_Latin1_General_CP1_CI_AS
132 SQLCHAR 0 1 "~" 132 V8_DRG_TYPE SQL_Latin1_General_CP1_CI_AS
133 SQLCHAR 0 1 "~" 133 V9_DRG_TYPE SQL_Latin1_General_CP1_CI_AS
134 SQLCHAR 0 2 "~" 134 PRDT_LINE_CD SQL_Latin1_General_CP1_CI_AS
135 SQLCHAR 0 1 "~" 135 CMPLCATN_6_SW SQL_Latin1_General_CP1_CI_AS
136 SQLCHAR 0 1 "~" 136 CMPLCATN_7_SW SQL_Latin1_General_CP1_CI_AS
137 SQLCHAR 0 1 "~" 137 CMPLCATN_8_SW SQL_Latin1_General_CP1_CI_AS
138 SQLCHAR 0 1 "~" 138 CMPLCATN_9_SW SQL_Latin1_General_CP1_CI_AS
139 SQLCHAR 0 1 "~" 139 CMPLCATN_10_SW SQL_Latin1_General_CP1_CI_AS
140 SQLCHAR 0 2 "~" 140 ADMSN_MNTH SQL_Latin1_General_CP1_CI_AS
141 SQLCHAR 0 2 "~" 141 DSCHRG_MNTH SQL_Latin1_General_CP1_CI_AS
142 SQLCHAR 0 7 "~" 142 PRNCPL_PRCDR_CD SQL_Latin1_General_CP1_CI_AS
143 SQLCHAR 0 7 "~" 143 PRNCPL_DGNS_CD SQL_Latin1_General_CP1_CI_AS
144 SQLCHAR 0 6 "~" 144 ST_PTNT_ID SQL_Latin1_General_CP1_CI_AS
145 SQLCHAR 0 16 "~" 145 UNQ_HOSP_ID SQL_Latin1_General_CP1_CI_AS
146 SQLCHAR 0 2 "~" 146 ST_PRVDR_SPCLTY_CD SQL_Latin1_General_CP1_CI_AS
147 SQLCHAR 0 41 "~" 147 ST_TOT_DTL_CHRG ""
148 SQLCHAR 0 8 "~" 148 ST_CNTY_MCD_CD SQL_Latin1_General_CP1_CI_AS
149 SQLCHAR 0 41 "~" 149 ST_BRTH_WGHT ""
150 SQLCHAR 0 1 "~" 150 HMO_RADMSSN_INDC SQL_Latin1_General_CP1_CI_AS
151 SQLCHAR 0 1 "~" 151 STAY_INDC SQL_Latin1_General_CP1_CI_AS
152 SQLCHAR 0 41 "~" 152 NUM_BILL ""
153 SQLCHAR 0 41 "~" 153 OTLR_DAYS ""
154 SQLCHAR 0 41 "~" 154 COINS_AMT ""
155 SQLCHAR 0 41 "~" 155 INPTNT_DCTBL ""
156 SQLCHAR 0 41 "~" 156 BLD_DCTBL ""
157 SQLCHAR 0 41 "~" 157 PRMRY_PYR_AMT ""
158 SQLCHAR 0 41 "~" 158 OTLR_AMT ""
159 SQLCHAR 0 41 "~" 159 DSPRP_SHR_AMT ""
160 SQLCHAR 0 41 "~" 160 INDRCT_MD_EDCTN_AMT ""
161 SQLCHAR 0 41 "~" 161 DRG_PRC ""
162 SQLCHAR 0 41 "~" 162 TOT_BILL_PER_DIEM ""
163 SQLCHAR 0 41 "~" 163 CPTL_TOT_AMT ""
164 SQLCHAR 0 41 "~" 164 ACQSTN_CHRG ""
165 SQLCHAR 0 41 "~" 165 PRV_RM_LOS ""
166 SQLCHAR 0 41 "~" 166 SM_PRV_RM_LOS ""
167 SQLCHAR 0 41 "~" 167 WRD_RM_LOS ""
168 SQLCHAR 0 41 "~" 168 PRV_RM_CHRG ""
169 SQLCHAR 0 41 "~" 169 SM_PRV_RM_CHRG ""
170 SQLCHAR 0 41 "~" 170 WRD_RM_CHRG ""
171 SQLCHAR 0 2 "~" 171 ICU_INDC SQL_Latin1_General_CP1_CI_AS
172 SQLCHAR 0 2 "~" 172 CCU_INDC SQL_Latin1_General_CP1_CI_AS
173 SQLCHAR 0 1 "~" 173 RX_INDC SQL_Latin1_General_CP1_CI_AS
174 SQLCHAR 0 3 "~" 174 TRNSPLNT_INDC SQL_Latin1_General_CP1_CI_AS
175 SQLCHAR 0 3 "~" 175 OPTNT_SRVCS_INDC SQL_Latin1_General_CP1_CI_AS
176 SQLCHAR 0 3 "~" 176 ORGN_INDC SQL_Latin1_General_CP1_CI_AS
177 SQLCHAR 0 41 "~" 177 NUM_DGNS_CDS ""
178 SQLCHAR 0 41 "~" 178 NUM_PRCDR_CDS ""
179 SQLCHAR 0 41 "~" 179 OTLR_CD ""
180 SQLCHAR 0 2 "~" 180 ESRD_CNDTN_CD SQL_Latin1_General_CP1_CI_AS
181 SQLCHAR 0 5 "~" 181 INTRMDRY_NUM SQL_Latin1_General_CP1_CI_AS
182 SQLCHAR 0 5 "~" 182 ADMSN_DGNS_CD SQL_Latin1_General_CP1_CI_AS
183 SQLCHAR 0 41 "~" 183 ROUT_LOS ""
184 SQLCHAR 0 41 "~" 184 RM_BRD_LOS ""
185 SQLCHAR 0 41 "~" 185 EXPCT_LOS_ALL ""
186 SQLCHAR 0 41 "~" 186 EXPCT_CHRG_ALL ""
187 SQLCHAR 0 41 "~" 187 EXPCT_CST_ALL ""
188 SQLCHAR 0 41 "~" 188 WAGE_NDX ""
189 SQLCHAR 0 41 "~" 189 MSA_ADJSTD_FCTR ""
190 SQLCHAR 0 2 "~" 190 PPS_VRSN SQL_Latin1_General_CP1_CI_AS
191 SQLCHAR 0 41 "~" 191 VRNC_CST_AMT_ALL ""
192 SQLCHAR 0 41 "~" 192 VRNC_LOS_ALL ""
193 SQLCHAR 0 41 "~" 193 VRNC_CHRG_AMT_ALL ""
194 SQLCHAR 0 5 "~" 194 HOSP_STATE_CNTY_CD SQL_Latin1_General_CP1_CI_AS
195 SQLCHAR 0 3 "~" 195 BILL_DRG_CD SQL_Latin1_General_CP1_CI_AS
196 SQLCHAR 0 2 "~" 196 ESRD_STNG_1 SQL_Latin1_General_CP1_CI_AS
197 SQLCHAR 0 2 "~" 197 ESRD_STNG_2 SQL_Latin1_General_CP1_CI_AS
198 SQLCHAR 0 2 "~" 198 ESRD_STNG_3 SQL_Latin1_General_CP1_CI_AS
199 SQLCHAR 0 7 "~" 199 ESRD_STNG_4 SQL_Latin1_General_CP1_CI_AS
200 SQLCHAR 0 7 "~" 200 ESRD_STNG_5 SQL_Latin1_General_CP1_CI_AS
201 SQLCHAR 0 2 "~" 201 RDLGY_INDC_ONC SQL_Latin1_General_CP1_CI_AS
202 SQLCHAR 0 2 "~" 202 RDLGY_INDC_DIAG SQL_Latin1_General_CP1_CI_AS
203 SQLCHAR 0 3 "~" 203 RDLGY_INDC_THER SQL_Latin1_General_CP1_CI_AS
204 SQLCHAR 0 1 "~" 204 RDLGY_INDC_NUC SQL_Latin1_General_CP1_CI_AS
205 SQLCHAR 0 1 "~" 205 RDLGY_INDC_CTS SQL_Latin1_General_CP1_CI_AS
206 SQLCHAR 0 1 "~" 206 RDLGY_INDC_OTH SQL_Latin1_General_CP1_CI_AS
207 SQLCHAR 0 5 "~" 207 PTNT_STATE_CNTY_CD SQL_Latin1_General_CP1_CI_AS
208 SQLCHAR 0 30 "~" 208 BRTH_DT ""
209 SQLCHAR 0 41 "~" 209 EXPCT_LIVE_PCT ""
210 SQLCHAR 0 2 "~" 210 PHYSN_SPCLTY_GRP SQL_Latin1_General_CP1_CI_AS
211 SQLCHAR 0 3 "~" 211 PHYSN_SPCLTY_CD SQL_Latin1_General_CP1_CI_AS
212 SQLCHAR 0 41 "~" 212 SPCLTY_LOS ""
213 SQLCHAR 0 41 "~" 213 RM_BRD_CHRG_AMT ""
214 SQLCHAR 0 41 "~" 214 RM_BRD_COST_AMT ""
215 SQLCHAR 0 1 "\r\n" 215 ETHNICITY SQL_Latin1_General_CP1_CI_AS
Can you paste your table structure too
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
awesome.
ASKER
My DAT file contain extraneous information which resulted in errors. However, I would like the rewards point to go to Aneesh for his time and efforts that he spent helping me. Thank you.
also make sure that you have a blank line at the end of the format file.