February 16, 2008 at 7:01 am
I am trying to import data from a csv file to a table but I am getting
error like this
Error 0xc02020a1: Data Flow Task: Data conversion failed. The data conversion for column "@column_Name" returned status value 4 and status text "Text was truncated or one or more characters had no match in the target code page.".
(SQL Server Import and Export Wizard)
Error 0xc020902a: Data Flow Task: The "output column "@column_Name" (54)" failed because truncation occurred, and the truncation row disposition on "output column "@column_Name" (54)" specifies failure on truncation. A truncation error occurred on the specified object of the specified component.
(SQL Server Import and Export Wizard)
I am unable to figure out this.
February 16, 2008 at 8:20 am
It would be helpful if you posted some sample data form the csv and the table specification. Based on the limited information given it sounds like you may have a character not supported by the code page/collation in the table into which you are importing the data. Have you tried using the error configuration and redirecting error rows to a file data source so you can see exactly what data is causing the error?
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
February 17, 2008 at 11:14 pm
Hi Thanks Jack I got to know what was wrong. I changed some of the datatype in the destination table and increased the length of some of the columns in source.It works fine now.
February 19, 2008 at 2:03 pm
If you are asked to do different datatype in the destination, i hope you know that the data conversion transformation can do that for you. But the datatype in SSIS will be different than what we see regularly. You can refer to MSDN if you need that. Just wanted to let you know that if ever they wanted you to do this. Just feeding some info here. 😉
[font="Verdana"]Imagination is more important than knowledge-Albert Einstein[/font]
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply