I've added a Data Conversion Task between the FF Source and OLEDB Destination for the Counter column, to make sure that it is passing as Data Type string[DT_STR] to OLEDB destination varchar(max) column, but still get this error:

[Data Conversion [2]] Error:

The conversion returned status value 4 and status text "Text was truncated or one or

more characters had no match in the target code page.".

It's coming into OLEDB destination as text stream [DT_TEXT] instead of what I set the Data Conversion Task to do, which is output Counter as DT_STR.

Ie 'External' Counter column on OLEDB destination task is DT_Text. I believe external means what's coming from the previous data flow task (in this case the Data Conversion Task), and that the 'Input' column what is passed forward?

Another thing I tried was to alter oledb destination data type for this column to fixed width CHAR(500), but this also made no difference.

Any ideas on what may be causing the truncation error?