Flat file Connection 4096 character limit

• Birdy

  Newbie

  Points: 2

  More actions

  July 8, 2013 at 5:30 am

  #277098

  Hello

  I am having to create a very wide flat file in a SSIS package with hundreds of columns. When I look at the output file, the header is truncated at 4096 characters.

  Has anyone else experienced this, and can this limit be changed?

• Koen Verbeeck

  SSC Guru

  Points: 259085

  More actions

  July 8, 2013 at 6:30 am

  #1630401

  How did you create the header?

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP