SSIS job failing successfully
I have a series of SSIS packages I use to copy data from a MYSQL database to SQLServer. The packages are set up to execute via a scheduled job. I each case, the data is copied, but the step that executes the package fails.
Date7/31/2008 12:54:42 PMLogJob History (Test t_accounts)
Step ID1Serverxxxxxx
Job NameTest t_accountsStep NameexecDuration00:00:02Sql Severity0Sql Message ID0Operator EmailedOperator Net sentOperator PagedRetries Attempted0
MessageExecuted as user: xxxxxxx. Microsoft (R) SQL Server Execute Package Utility Version 9.00.3042.00 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 12:54:42 PM DTExec: The package execution returned DTSER_SUCCESS (0). Started: 12:54:42 PM Finished: 12:54:43 PM Elapsed: 0.969 seconds. The return value was unknown. The process exit code was -532459699. The step failed.
I've turned on logging for every event in the package, but don't see anything that looks like a failure.
Details
Source = MYSQL 5.0 using MYSql Connector /.Net 5.1.6
Destination = MSSQL 2005 64-bit
This may or may not be related, but I've noticed that when I execute these packages in VStudio, they execute correctly as well, but VS won't shut down cleanly afterward.
Any help would be greatly appreciated. I can provide moredetails when/if needed.
July 31st, 2008 4:15pm
Hi Ron,
I'd same error !
When I call the SSIS Package via Job (Proxy Account) . Some times it did return follow error message.
"The package execution returned DTSER_SUCCESS (0). The return value was unknown. The process exit code was -1073741819. The step failed."
And I'd write a custom log file. And looks like everything is fine!.
(Even the last step of my SSIS is send email to notify me it's finisted, I'd got the email ! )
It looks like a DTSER_SUCCESS(0) <=== Success , doesn't get known by Job Agent !
Wilson
October 25th, 2010 7:22am
Please check the event viewer. Let us know your observation..
Let us TRY this |
My Blog :: http://quest4gen.blogspot.com/
Free Windows Admin Tool Kit Click here and download it now
October 25th, 2010 2:14pm