May 8, 2012 at 9:01 am
Hi,
I am loading SQL server DB data to Access Database when i open the Access File it says that File is Corrupted.
But when I load One table to access using SSIS its fine. Corruption occurs when I am, trying to load all the tables at once in Access Database uisng SSIS.
Please Help me with this Issue
May 8, 2012 at 2:58 pm
In detail Errors
[OLE DB Destination [424]] Error:
SSIS Error Code DTS_E_OLEDBERROR.
An OLE DB error has occurred. Error code: 0x80004005.
[OLE DB Destination [424]] Error:
SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR.
The "input "OLE DB Destination Input" (437)" failed because
error code 0xC020907B occurred,
and the error row disposition on "input "OLE DB Destination Input" (437)" specifies failure on error.
An error occurred on the specified object of the specified component. There may be error messages posted before this with more information about the failure.
[SSIS.Pipeline] Error:
SSIS Error Code DTS_E_PROCESSINPUTFAILED.
The ProcessInput method on component "OLE DB Destination"
(424) failed with error code 0xC0209029 while processing input "OLE DB Destination Input" (437).
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.
[OLE DB Source [1]] Error:
The attempt to add a row to the Data Flow task buffer failed with error code 0xC0047020.
[SSIS.Pipeline] Error:
SSIS Error Code DTS_E_PRIMEOUTPUTFAILED.
The PrimeOutput method on component "OLE DB Source" (1) returned error code 0xC02020C4.
The component returned a failure code when the pipeline engine called PrimeOutput().
The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing. There may be error messages posted before this with more information about the failure.
May 9, 2012 at 5:46 am
How many tables are you writing to the Access db? Are you writing the records in parallel or in sequence?
Simple question, but if it works for one table, does it work for two? Is the problem actually being masked by an issue in a specific table?
HTH,
Rob
May 9, 2012 at 7:24 am
Thankyou for replying..
I am processing parallelly two tables at a time
Table 1 has 2400167 and Table 2 has 259702
please let me the solution ..............That would be great help!!
May 9, 2012 at 8:01 am
Got one more issue tried to load one table in different DB .. to Access DB
got same errors... sometimes it ran sucessfully access file is got crroupted...
thanks
May 10, 2012 at 1:31 pm
Can you try running them sequentially? Load all of Table 1, then Load all of Table 2. Give this a try. Does this shed any light on your problem?
Rob
May 10, 2012 at 2:02 pm
Hi,
I tried to run sequentially it same and as i said when tried to load another table to access it got same errors as before
May 15, 2012 at 9:51 pm
This was removed by the editor as SPAM
May 16, 2012 at 9:58 am
Have you tried to set the Access destination to Ignore Errors or redirect? I'd be curious if some funky value is attempting to be written but can't, yet SSIS doesn't get a good error from Access so just fails as gracefully as it can, corrupting Access on the way down.
If you can get the process to complete, you may then be able to locate what is causing the original error and maybe have a way around the whole debacle.
Barring that, stick a data viewer on the flow to Access and take a look at the data going in.
While Access can be quite corruptable, it seems that something is causing it and I'd check data first. If it is possible to slim down the volume of data in your flow, try that. Volume should not be an issue for Access but it may help you narrow down the list of suspects.
May 23, 2012 at 1:39 pm
Thankyou so much for replying me i resolved my issue........
May 24, 2012 at 12:54 pm
I'm glad it's working for you!
can you please post what worked to solve it?
It's always nice to see the solution in the same thread with the problem so others with same issue can try your solution.
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply