I have an SSIS project that works fine on files smaller than 8k.
When i use a file larger than 8k, it fails due to a truncation error.
I have tracked the issue to the 'set column width' which is limited to 8000.
How do i change the 'set column width' field to varchar(max) and get around my issue ?
BTW some of my input files are 35k.