I'm loading data from a flatfile TXT to a SQL table in SSIS, with a Data Conversion step in between.
In my data conversion I can see my column property before the load is string(DT_STR) with a length of 100. Likewise, in my SQL table design view, my data type is Varchar(100).
My problem is when I perform the data flow task of loading into SQL from the Flatfile, it truncates the data from my flat file and only loads 50 characters instead of the full string. How can I resolve this in SSIS? Is there an element I'm missing here?