<div>
<div class="content wysiwyg-content">
Hi!<br />
<br />
SSIS package &gt;&nbsp;Flat File Connection Manager Editor &gt;&nbsp;Advanced &gt;&nbsp;OutputColumnWidth<br />
<br />
I am looking to set a default OutputColumnWidth length. I am referring in particular to increasing the default length for DT_STR data types.<br />
<br />
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.<br />
<br />
Any ideas?<br />
<br />
Thanks,<br />
Katie
</div>
</div>


Hi!

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?

Thanks,
Katie

SSIS Flat File Connection Manager Editor - OutputColumnWidth

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.