Click here to Skip to main content
15,566,625 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
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 ?


What I have tried:

I looked into the connection manager, column has set to string[DT_STR] and OutputColumnWidth to 50.
Posted
Updated 3-Aug-18 1:06am
Comments
ZurdoDev 24-Jul-18 8:08am    
But your data has more than 50 characters. Look at the actual data.

1 solution

Hi,

Try to change the length in Data conversion component

Thanks
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900