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
August 4th, 2008 8:29pm
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/
October 25th, 2010 2:14pm