December 8, 2011 at 6:41 am
Hi All
I new to this forum ,I am encountering with one issue in SSIS Package .
SSIS package is created in local machine it's working fine,when i added this to scheduler it's not running successfully in regular intervals.
Ex: Job ran for 6 times then first 2 times package ran fine , 3rd time failed, 4th time success, 5th time failed and 6th time success like that it's not success continuously.
Error Message :
An OLE DB error has occurred. Error code: 0x8000FFFF.
component "OLE DB Source" (1) failed the pre-execute phase and returned error code 0xC0202009.
My Source is Oracle , destination is Flat file (.csv). I am struggling past two weeks ,any one can suggest to resolve the issue and run package successfully.
December 8, 2011 at 7:03 am
Is there a longer error message available?
Does the package ever fail when run in Visual Studio?
December 8, 2011 at 7:19 am
Hi Phil,
Thanks for response.
In visual studio it's ran fine. When the package failed it's returns only the above error message displaying.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply