SSIS error while loading pipe delimited data from flat file to SQL table.

Quote:

I am looking at existing ssis package.
I download the package from source control. Change connection managers to point to my local
dev envirionment.
Task is to read from Flat file and to load on Sql Db.

File is '|' delimited flat file. In connection manager, Header row delimiter has set as {LF}.

While executing task, I ran into several error and one of that is

[curr user file [2]] Error: Data conversion failed. The data conversion for column
"customfield_storeid"
returned status value 4 and status text "Text was truncated or one or more characters had no match in the target code page.".

I looked into the connection manager, column has set to string[DT_STR] and OutputColumnWidth to 50.

In my DB table, for that column , it is varchar(50). So it seems there is not anything wrong.



If I could change error output to ignore truncation error, it would not show error.
But I do not want to change what has previously set for the package.

How do I resolve it ?

I looked into the connection manager, column has set to string[DT_STR] and OutputColumnWidth to 50.