Windows Server 2008 R2
I finally got a package created that would get past the 64 bit non support of Excel. I had to use the wizard, but now the data set from my query is being written into my Excel spreadsheet perfectly. I've tested it 3 or 4 times. Good results every time.
Now, I create a job and call the SSIS package and start getting that error again:
Description: SSIS Error Code DTS_E_OLEDB_EXCEL_NOT_SUPPORTED: The Excel Connection Manager is not supported in the 64-bit version of SSIS, as no OLE DB provider is
What's going on?