Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Gene Wirchenko
  Where is Gene Wirchenko?
 Kamloops
 Canada
 Gene Wirchenko
 To: Cecil Champenois
  Where is Cecil Champenois?
 Little Elm
 Texas - United States
 Cecil Champenois
 Tags
Subject: RE: BULK INSERT from CSV file errors
Thread ID: 395928 Message ID: 395951 # Views: 41 # Ratings: 0
Version: Not Applicable Category: Databases, Tables and SQL Server
Date: Tuesday, January 21, 2014 6:44:49 PM         
   


> Well, I am not sure how to handle the errors, which center on the GrpNo and EMP_SSN fields, both of which do not have double quotes around the data in each of their fields. The errors are as follows, regarding data types conflicting:

Neither am I without seeing any of the data.

[snip]

> create table dbo.WebTPA_INPUT_File (
> GrpNo nvarchar(10), Ins_Name nvarchar(50), Emp_SSN nvarchar(9), MemberID nvarchar(12),

Nine characters for SSN? Does the file have them in that format or with the hyphens? If the latter, you have a truncation/conversion issue. GrpNo might have the same problem.

[snip]

Sincerely,

Gene Wirchenko

ENTIRE THREAD

BULK INSERT from CSV file errors Posted by Cecil Champenois @ 1/21/2014 2:42:41 PM
RE: BULK INSERT from CSV file errors Posted by Cetin Basoz @ 1/21/2014 3:46:45 PM
RE: BULK INSERT from CSV file errors Posted by Gene Wirchenko @ 1/21/2014 6:44:49 PM