SSIS Flat File Fixed Width - No Line Feed Options

• SteveEClarke

  SSCertifiable

  Points: 5161

  More actions

  June 15, 2012 at 5:27 am

  #275771

  Hi Guys,

  I have created a data table from SSMS as just ONE column in the foramt that I require. I now need to convert that to a fixed width text file - so am using SSIS to create the package to do so.

  I have 2 problems ;

  1. When I export - I am getting the columns wrapped without having a "Line Feed" or "Hard Return"

  2. When I try and configue the Flay File connection manager to apply the LINE FEED - I get a dialogue box appear when I choose the Columns - "Input column widths are ignored because they contain zeros or negatives"

  Am I missing something really obvious ?

  The table is populated with multiple lines and the data flow process is validated and goes green when run.

  Thanks

  ________________________________________________________________________________________________
  Regards
  Steve
  SQL 2008 DBA/DBD - MCTS/MCITP

  Please don't trust me, test the solutions I give you before using them.

• SteveEClarke

  SSCertifiable

  Points: 5161

  More actions

  June 15, 2012 at 5:44 am

  #1501557

  Just an update -

  Because I am using one column from the input table - I have changed to use delimited file as output, which now does the job.

  ________________________________________________________________________________________________
  Regards
  Steve
  SQL 2008 DBA/DBD - MCTS/MCITP

  Please don't trust me, test the solutions I give you before using them.