Hi everyone,

Excel file: one column is large data first 28 rows are empty then large description around 2000 character.

when I am trying to load it  throw me error . It is problem of by default guessing row in excel. we can change it from regedit but I don't have that rights and also it decrease the performance if I put is 0. so I want some other alternate solution.

Please guys Help me to for that.

Thanks



Are you loading data into Excel file or Reading from Excel file. 

OPen the data flow task and change the string value to 2000. This should avoid the problem.

Hi Meerack,

can you post more details of your error ?

Are you loading data into Excel file or Reading from Excel file. 

OPen the data flow task and change the string value to 2000. This should avoid the problem.

• Proposed as answer by Katherine XiongMicrosoft contingent staff, Moderator 23 hours 47 minutes ago

Hey I did that I am facing like excel file that donot read more then 255 character.

how to resolve that?

Excel text fields have a max length of 255 when importing. If using larger than this, you'll need to set up that field as a memo and not a text.

I believe these are the steps . . .

Right-click your Excel Source, and select "Show Advanced Editor".
Go the the "Input and Output Properties" tab.
Expand the "Excel Source Output" node.
Expand the "External Columns" and "Output Columns" nodes.
Click on the appropriate column under "External Columns".
Change DataType to "Unicode Text Stream".
Click on the appropriate column under "Output Columns".
Change DataTYpe to "Unicode Text Stream".
Click "Ok".

Or, this . . .

http://www.sql-server-performance.com/2009/Using-SSIS-Import-an-Excel-file-which-has-columns-with-moe-than-255-characters/