Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 531
  • Last Modified:

MSSQL BULK INSERT PROBLEM

I have another problem. I am getting a truncation error for:

BULK INSERT PATRONLOADZETA2 FROM 'c:\patrondata\PATRONLOADFORILLIAD4.txt' WITH (FIELDTERMINATOR=',',ROWTERMINATOR=' ' )

It is saying Column 13 has bulk conversion error

Column 13 HAS PROPERTIES: (varchar(3),NULL)
i am simply inserting the string:  YES
I the input file the field appears correct  ,YES,
(WITH NO QUOTATION MARKS)

I am perplexed.
0
notcjw
Asked:
notcjw
1 Solution
 
nishant joshiTechnology Development ConsultantCommented:
is your text file having string of only 3 char or less character after 12 "," (comma)?
check it.or attached sample of your txt file..

Thanks,
Nishant
0
 
selva_konguCommented:
before assigning the value trim it and assign
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now