SSIS Flat File Connection Manager Editor - OutputColumnWidth


SSIS package > Flat File Connection Manager Editor > Advanced > OutputColumnWidth

I am looking to set a default OutputColumnWidth length. I am referring in particular to increasing the default length for DT_STR data types.

I have a package set up to read flat files that will at times have different column names and I'm having truncation issues because the default for the DT_STR data types appears to be 255, I want to increase the default.

Any ideas?

Who is Participating?
vdr1620Connect With a Mentor Commented:
You can change the Value from 255 to required length and then map the Source and Destination columns again .. so that the metadata gets updated .. The text file will use the suggested/changed length
DixieDevAuthor Commented:
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.