March 4, 2020 at 3:37 pm
Hi,
I have SSIS package that reads data from Excel file and load into sql server.
The package is running successfully so far. Recently, my laptop restarted with windows updates.
Since that time I am getting error at Excel Source
The AcquireConnection method call to the connection manager "Survey_Titles_File_Conn" failed with error code 0xC0202009
When I double click Excel source and click Preview, I can see data. When I run the package I am getting above error.
I have changed project properties "Run64BitRuntime = FALSE
How can I resolve this error
March 4, 2020 at 3:40 pm
According to Googling, that error code means that the connection failed to the file, normally is because it does not exist. Is the file name dynamic? If so, have you set the DelayValidation property to True?
If this isn't applicable, what are all the related errors, as SSIS tends to provide the full information over several of them.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
March 4, 2020 at 3:50 pm
Are you seeing the error when running the package from VS? If not, how are you running it?
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
March 4, 2020 at 3:55 pm
Yes, I am running from VS
It is working until yesterday. Nothing changed in the package
March 4, 2020 at 4:03 pm
I have deployed to SSISDB and executed from there. Surprisingly, it has executed successfully.
Why is this problem in VS?
March 4, 2020 at 4:05 pm
Presumably you have the ACE drivers installed on your PC?
Do you have 32-bit, 64-bit or both?
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
March 4, 2020 at 4:09 pm
I have 64 bit(as part of Office 365) and also 32 bit(AccessDatabaseEngine.exe)
March 4, 2020 at 4:14 pm
As that is the case, you shouldn't have to change Run64BitRuntime.
I've run out of ideas right now, sorry.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply