You need to trace the path of the data, from flat file source to destination, using the Advanced Editor to view the data types that SSIS is using as the data passes through the pipeline.
Phil, here's the tracing:
Output for Counter on FF Source
External Columns:DT_STR
Output column: DT_STR
Output for Counter on Destination OLE DB
External Columns: DT_TEXT
Input Columns: DT_STR
I have no data flow tasks between the FF Source and the OLEDB destination, yet for some reason the data type flips to DT_TEXT.
Have you seen this before and what do to about it?