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.
DateÃÂ ÃÂ 7/31/2008 12:54:42 PM
LogÃÂ ÃÂ Job History (Test t_accounts)
Step IDÃÂ ÃÂ 1
ServerÃÂ ÃÂ xxxxxx
Job NameÃÂ ÃÂ Test t_accounts
Step NameÃÂ ÃÂ exec
DurationÃÂ ÃÂ 00:00:02
Sql SeverityÃÂ ÃÂ 0
Sql Message IDÃÂ ÃÂ 0
Operator EmailedÃÂ ÃÂ
Operator Net sentÃÂ ÃÂ
Operator PagedÃÂ ÃÂ
Retries AttemptedÃÂ ÃÂ 0
Executed 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.
Source = MYSQL 5.0 using MYSql Connector /.Net 5.1.6
Destination = MSSQL 200
View Complete Post