Error: Failed to retrieve long data for a column in SSIS

[Excel Source [16]] Error: Failed to retrieve long data for column “ColumnName”

Error received during execution of SSIS package by changing the new excel file:


[Excel Source [16]] Error: Failed to retrieve long data for column "Project SharePoint Site".

Solution: I fixed this error with the following options: For fixed I tried the first two options collectively. I tried the third option which also fixed the issue.

  1. Put IMEX=1 in the connection string of Excel Connection Manager.

Edit the Connection String and put at last as shown below:

2. You need to edit the registry setting for TypeGuessRows to 0 which is default to 8. With this parameter, Excel check the first 8 rows to decide the maximum the length for column.

3. You can Right click on the Excel Source Data flow and open show advance editor. Go to last tab Input and Output properties–> Expand the Excel Source output –> Expand the output column –> Select the column on the left panel –> Go to the right panel and increase its length to the maximum you want, In Example, I change from 255 to 4000.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.