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?
Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.