December 18, 2007 at 12:54 pm
I used the Import/Export wizard to create a SSIS package to integrate data from SQLServer2005 into Access. When I try to run the package, i get the following error:
"[DTS.Pipeline] Error: The ProcessInput method on component "Destination - tblEmployee" (58) failed with error code 0xC0202009. The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running. "
Any help would be greatly appreciated.
Bob
December 18, 2007 at 1:05 pm
What version of SQL 2005 (x32 or x64)?
December 18, 2007 at 1:08 pm
Sorry,
x32. And the Access driver i selected is the Native OLE DB\Microsoft Jet 4.0 OLE DB Provider.
December 18, 2007 at 1:11 pm
I'm at a loss right now. I was hoping you were running x64 since, as far as I know, MS hasn't released 64 bit drivers for Access as of yet.
If any ideas come to mind, I'll get back to you.
Sorry I can't be of help here.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply