Home Forums Data Warehousing Integration Services Enumerator cannot enumerate multiple Excel files/worksheets RE: Enumerator cannot enumerate multiple Excel files/worksheets

  • December 11, 2012 at 10:00 pm

    #1567687

    If you are running this off BIDS, right click on the Project properties > Configuration Properties > Debugging. Set the Run64BitRunTime to False.

    If you are running it standalone using the DTEXEC tool, try using the 32-bit/64-bit version of the tool depending on the version of the ACE driver that you have installed - You are using the ACE OLEDB Driver right?