how to handle *char(max) from sql to ssis flat file

  • I've long wondered this but have been too lazy to ask, and in the past (admittedly) just ignored truncation (and it probably never happened, but still).

    So you're building an SSIS package to output data to a flat file.  The stupid connection manager has no way to specify MAX for the length, so.....What do you do ???  I sure hope the answer is not "just don't output them", as that's not exactly an option.........

  • Provided the source column was compatible your output field in the Flat File Connection Manager could be text stream[DT_TEXT]

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply