troubleshooting Question

Excel Connection Manager failed with error code 0xC0202009

Avatar of LenTompkins
LenTompkinsFlag for United States of America asked on
Microsoft SQL ServerMicrosoft DevelopmentSSIS
8 Comments1 Solution3074 ViewsLast Modified:
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?
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 8 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 8 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros