Excel Connection Manager failed with error code 0xC0202009
Posted on 2013-05-11
What driver will I need to add to our server to get an SSIS job that creates Excel files to run? I have the job set to "Use 32 bit runtime" enabled but I keep getting Excel Connection Manager failed with error code 0xC0202009. When I read other posts they say I need to download Excel jet drivers. I have found the 2007 Office System Driver: Data Connectivity component, but when I read the details, it states that this is not intended for server side programs where the code will run under a system account. I want to run the SSIS job weekly from SQL Server Agent. Is this the correct or should I be using another dll?