July 28, 2011 at 7:51 am
Hi ,
i am trying to transfer data from Excel to Access DB, i am receiving the following errors
1. [OLE DB Destination [2960]] Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E03.
2. [SSIS.Pipeline] Error: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "OLE DB Destination" (2960) failed with error code 0xC0202009 while processing input "OLE DB Destination Input" (2973). 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. There may be error messages posted before this with more information about the failure.
3. [SSIS.Pipeline] Error: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "Sort" (1879) failed with error code 0xC0047020 while processing input "Sort Input" (1880). 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. There may be error messages posted before this with more information about the failure.
I tried the same package to excel destination it has flown successfully, i have converted the destination to OLEDB to transfer the data to access file. i am unable to identify the reason for this and how to resolve these issues.
Any help is appreciated!!!!
July 29, 2011 at 12:26 pm
Seems the error has something to do with a sort transformation?? Is it possible you are not passing thru required fields?
I would check table settings in Access to check on nulls, indexing, etc., to make sure the data is valid for input.
Can you manually import the Excel data to the Access target? Make sure of that outside of the package.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply