Suppressing extra columns on flat file destination (CSV)

• gbritton1

  SSCertifiable

  Points: 6522

  More actions

  June 25, 2014 at 10:05 am

  #290341

  I'm working on a package that has a CSV file as its destination. My data stream at that point has only 6 columns, However, the FF transform thinks it has 13. I can see this since I produce the header row in the output file, which currently looks like this:

  "Email","Opt In Date","Opted Out","Opt In Details","Email Type","Opt Out Details","Column 6","Column 7","Column 8","Column 9","Column 10","Column 11","Column 12","Column 13"

  How can I tell SSIS I don't want columns 6 to 13?

• gbritton1

  SSCertifiable

  Points: 6522

  More actions

  June 25, 2014 at 10:35 am

  #1724721

  Solved it:

  Problem was the file connector thought it had the extra columns. I deleted them in the connection manager.