Error while importing data from Text File to SQL
Hi Guys, i have a text file having around 9000 records with 8 fields in table. when i move data i am getting error only for the address column. it has data something like.. 1001 Heathrow Park Lane, Ste 5001, Lake Mary, FL, 32746 Its a pipe delimited file. its giving me an error : [Flat File Source [1]] Error: Data conversion failed. The data conversion for column "Address" returned status value 4 and status text "Text was truncated or one or more characters had no match in the target code page.". its not even reaching at data conversion task, it fails at Flat File Source. if i take that column out and move records it works. i tried changing the lenght of the datatype but still the same error. What do i do?
November 9th, 2010 4:52pm

It probably has a badly formatted address, the error will have an exact line number where the issue is, go inspect this line. Most probably it is an unreadable character. Use NVARCHAR for the column if you have it as varchar and all must work thereafter.Arthur My Blog
Free Windows Admin Tool Kit Click here and download it now
November 9th, 2010 4:59pm

you can try increase the width of the column where you are getting this error. Gaurav Gupta http://sqlservermsbiblog.blogspot.com/
November 9th, 2010 5:33pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics