July 24, 2012 at 6:47 am
I got following error in SSIS 2005 Package, which was configured in SQL JOB
"Executed as user: PHYSIOCORP\physiosvcacct. ILED. Thread "WorkThread0" has exited with error code 0xC0047039. There may be error messages posted before this with more information on why the thread has exited. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 1:07:42 AM Finished: 1:08:33 AM Elapsed: 50.86 seconds. The package execution failed. The step failed."
In this SSIS Package OLEDB Source and flatfile destination.
in the OLEDB Source SQL query used with multi joins between Producation database tables
and this data will load into flat file.
Can you clarify me any one, why this error is coming?
July 24, 2012 at 7:03 am
The key in the error message is
There may be error messages posted before this with more information on why the thread has exited
If you scroll up the output window and look for the lines which begin Error it will tell you more information about the error.
If not post the whole output window here so that we can see the entire stack.
July 24, 2012 at 7:16 am
this is only total error message, i have taken from job history
July 24, 2012 at 7:20 am
Without a more detailed error it could really be anything.
I would recommend running the package in BIDS so that you can get the full output so we can debug further.
July 24, 2012 at 7:57 am
this issue was coming in spcific time (regular scheduled run)
this is running fine when restart this step or individually run the package.
July 24, 2012 at 8:00 am
without a more detailed error, we cannot say what causes it to fail on the scheduled run.
July 24, 2012 at 8:21 am
do you have any logging in the package?
if so can you not query the sysdtslog90 table and see whats going on?
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply