• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1688
  • Last Modified:

SSIS Flat File Connection Manager Editor - OutputColumnWidth

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
0
DixieDev
Asked:
DixieDev
1 Solution
 
vdr1620Commented:
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
0
 
DixieDevAuthor Commented:
Thanks!
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now