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:
12.0
1
1       SQLCHAR             1       5       "~"      1     CNVRSN_SRC_CD                              SQL_Latin1_General_CP1_CI_AS

Open in new window



My 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 

Open in new window



Would someone know how to resolve this error or what I am doing wrong?  Also, what does this message mean?

Thank you in advance.
Maria TorresData AnalystAsked:
Who is Participating?
 
Maria TorresConnect With a Mentor Data AnalystAuthor Commented:
Aneesh, I was able to determine what was causing the problem.

I exported the data from an Oracle table, via PL/SQL script file.  For every 50,000 records, the PL/SQL software placed a header in the dat file.  So when I tried to import the data into SQL server, via BCP, an error occurred every 50K records.

Once I removed the headers, I was able to import the data without any issue.

I, also, would like the reward points to be forwarded to you since you took time to work with me on this problem.  Thank you for all you help.
0
 
Aneesh RetnakaranDatabase AdministratorCommented:
Move the format file and the dat file to c:\temp and check whether that works  -- could be a permission issue
also make sure that you have a blank line at the end of the format file.
0
 
Maria TorresData AnalystAuthor Commented:
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.
0
Cloud Class® Course: Certified Penetration Testing

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

 
Aneesh RetnakaranDatabase AdministratorCommented:
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
0
 
Maria TorresData AnalystAuthor Commented:
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.
0
 
Aneesh RetnakaranDatabase AdministratorCommented:
Your format file shows only 1 field CNVRSN_SRC_CD
0
 
Maria TorresData AnalystAuthor Commented:
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

Open in new window

0
 
Aneesh RetnakaranDatabase AdministratorCommented:
Can you paste your table structure too
0
 
Aneesh RetnakaranDatabase AdministratorCommented:
awesome.
0
 
Maria TorresData AnalystAuthor Commented:
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.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.