Post reply

SSIS Truncation Issue

  • January 8, 2015 at 3:49 am

    #397846

    I have a excel sheet with 3cols(Q1,Q2,Q3)and 100 rows . Q1,Q2,Q3 columns first 8 rows having the length of below 255, and after that all the rows having above 255. when am trying to load excel sheet data into Sql server using SSIS the package was failed with " Truncation Error" . How to fix this issue? can any one help?

  • January 8, 2015 at 7:39 pm

    #1768948

    Believe it or not, this is the standard/default behaviour of the Excel provider.

    Have a look at http://support.microsoft.com/kb/189897 - it tells you of the registry change that you can use for modify the number of rows that are used to determine the length of the column.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply