Flat file load to SQL table... Flat file columns are fixed width .. which option i need to select

• nithiyanandam-447806

  Ten Centuries

  Points: 1197

  More actions

  January 9, 2012 at 11:29 pm

  #254712

  I have a flat file that looks something like this:

  val1 val2 val3

  val1 val2 val3

  val1 val2 val3

  I need to import this value to table through SSIS.

  I have no idea to which option to used this for flat file connection manager.

  Can anyone help on this...

  Thanks

  NithiyanandamaS

• Nimesh_Parikh

  SSC-Addicted

  Points: 464

  More actions

  January 10, 2012 at 4:05 am

  #1430978

  Keep first screen as it is while configuring your FlatFileSource connection manage.

  Go to columns : select Row delimiter as "{CR}{LF}"

  select column delimiter as " "

  Thanks,

  Nimesh