How to modify SSIS "Flexible File Source" character limit

Question

Hello everyone,

I use SSIS to pour CSV data into a database. I use the "Flexible File Source" package to get data from Azure Blob Storage.

When trying to do that with a rather big CSV file, I got one of my values that got truncated.

I did a bit of debugging, and I discovered that there is a 100 character limit for the values for this package.

For instance this will not be truncated:

column1,column2

First value,aaaaaaaaaaaaa...(99 times)

However, this CSV will be truncated :

column1,column2

First value, aaaaaaaaaaaa...(101 times)

This is a problem, as this component does not give the choice of the character limit.

Do you know any work-around ?

Thanks in advance

Answer 1

Hi @D2d3d4d5,

Right click Flexible File Source and choose 'show advance editor', Input and output property.

Change the output column length to see if you have limit it to 100.

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.