Just a quick post on getting the Excel connection manager to work in 64 bit SSIS and 64 bit BIDS. You may have run into this error: DTS_E_OLEDB_EXCEL_NOT_SUPPORTED This happens when trying to use the Excel Source in 64 bit BIDS or DTEXEC. For my own reference as much as yours, here is an excellent blog post on how to fix the error. http://blogs.msdn.com/b/priyo/archive/2009/05/04/dts-e-oledb-excel-not-supported-resolved.aspx?CommentPosted=true The short answer is, for BIDS, go to the Project Properties | Debugging | Run 64 Bit Runtime | set to False [cid:[email protected]] For DTEXEC, change the properties of the Step in the SQL Agent job that is running the package. Go into the Step and pick the Execution Options tab and set the 32 bit mode to on. [cid:[email protected]] Cheers