November 27, 2012 at 3:08 pm
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
November 27, 2012 at 10:46 pm
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.
November 28, 2012 at 12:42 am
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.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply