Import from multiple Flat and excel files in the same folder

• engg.pankaj

  SSC-Addicted

  Points: 470

  More actions

  November 27, 2012 at 3:08 pm

  #285451

  Hi there,

  Need help with importing from multiple Flat and excel files in the same folder (or its sub-folders) into a SQL table. The flat file and the excel sheets have the same structure.

  I know how to import from Multiple text files (Or excel files) by the use of For Each Container, however I do not know what to do when to import both type of files i.e. Excel as well as flat files in the same task.

  Can someone please help?

  Thanks

• Kumara1011

  SSC-Addicted

  Points: 424

  More actions

  November 27, 2012 at 10:46 pm

  #1562926

  we can write a condition in precedence constraints like which type of file need to send.

  we can send that to same destination taking 2 OLE DB destination with same table.

• Kumara1011

  SSC-Addicted

  Points: 424

  More actions

  November 28, 2012 at 12:42 am

  #1562951

  small example :

  right("D:\\filesource\\emp1.xls",3)=="xls"

  right("D:\\filesource\\emp1.txt",3)=="txt"

  mention this condition in precedence constraint to send text files to one destination and excel to other destination using same table in OLE DB.