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?