Hi, I am trying to create a SSIS package to import multiple excel files from a directory to simple SQl table. The DataFlow task works fine with one excel file and with out foreach. On adding foreach loop, the package fails as below. I am using the instructions from Microsoft at http://msdn.microsoft.com/en-us/library/ms345182.aspx#
Any pointers would be helpful.
" Error at Package [Connection manager "Excel Connection Manager"]: An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft JET Database Engine" Hresult: 0x80004005 Description: "Could not find installable ISAM.".