[Excel Source ] Error: Failed to retrieve long data for column “ColumnName”
Error received during execution of SSIS package by changing the new excel file:
[Excel Source ] 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.
- 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.