April 22, 2010 at 11:45 am
Hi there! I am banging my head against the wall with this problem I'm having with a flat file.
I'm trying to use the import wizard to bring a flat file in and then save it as an SSIS package.
In the wizard, I have managed to (I believe) work out the delimiters for the file. However, when I get to the import task it keeps failing saying this:
Messages
Error 0xc02020a1: Data Flow Task: Data conversion failed. The data conversion for column "Column 27" 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 27" (118)" failed because truncation occurred, and the truncation row disposition on "output column "Column 27" (118)" specifies failure on truncation. A truncation error occurred on the specified object of the specified component.
(SQL Server Import and Export Wizard)
I cannot figure out why this is happening especially since I have made every single field varchar(max).
April 22, 2010 at 12:37 pm
I would venture a guess that the source has it defined with a length of 255, you might right click on it and choose the Advanced Editor.. I think that it what you'll see..
CEWII
April 22, 2010 at 12:59 pm
Ok, so I just looked in the advanced tab... it says the column widths are all 50...
So, are you saying I need to change the column widths here in the advanced tab?
April 22, 2010 at 1:24 pm
Woot thanks! With some trial and error it finally went in!!!
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply