July 30, 2008 at 7:20 pm
Hi all,
I am very new to SSIS. I have a truncation Error problem when importing a flat file using SSIS.
I would appreciate any help for this problem. Thanks in Advance.
July 30, 2008 at 8:06 pm
That usually means that one of your fields is bigger than how you defined it. Try looking at your input file and see if you can tell which field it is. If that fails, try redirecting the truncated rows to another dataset. That will at least narrow down which rows contain the long field.
July 31, 2008 at 10:06 am
In Flatfile connection manager editor, advanced options like output column width, change it to bigger number, can be given same as your database table column width for this column...
-V
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply