July 11, 2011 at 6:57 am
I have developed a SSIS package that shoves everything into a Excel Spreadsheet and then sends that off to a FTP task. During my development, I had to Project Properties, debugging, and set the Run64BitRuntime to False. Now that I have deployed my package to my SSIS server and am attempting to put into SQL job, I am dealing with this again.
My SSIS server is a Windows Server 2008 R2 Standard 64-bit box. I am getting the following error message from my SQL Agent Job:
The Excel Connection Manager is not supported in the 64-bit version of SSIS, as no OLE DB provider is available. End Error Error: 2011-07-11 08:31:01.37 Code: 0xC020801C Source: DFT - Get Org Info EX_DST - Get info into Excel [348] Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "Excel Connection Manager" failed with error code 0xC00F9304. There may be error messages posted before this with more information on why the AcquireConnection method call failed. End Error Error: 2011-07-11 08:31:01.38 Code: 0xC0047017 Source: DFT - Get Org Info SSIS.Pipeline Description: component "EX_DST - Get info into Excel" (348) failed validation and returned error code 0xC020801C. End Error Error: 2011-07-11 08:31:01.38 Code: 0xC004700C Source: DFT - Get Org Info SSIS.Pipeline Description: One or more component failed validation. End Error Error: 2011-07-11 08:31:01.38 Code: 0xC0024107 Source: DFT - Get Org Info Description: There were errors during task validation. End Error DTExec: The package validation returned DTSER_FAILURE (1). Started: 8:31:00 AM Finished: 8:31:01 AM Elapsed: 1.014 seconds. The package execution failed. The step failed.
I was searching within the SQL job, to see what can be done and I don't see much. Also attempting to Google this, alot of stuff comes up, but unfortunately it does not make a whole lot of sense.
Any and All Help will be greatly appreciated.
Thanks...
July 11, 2011 at 7:47 am
You need to run the package in 32-bit mode.
In the SSIS jobstep, there is a checkbox that you can select.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 11, 2011 at 9:56 am
Thanks Koen, I looked in all the tabs of the job step and for some reason did not see that check box.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply