Question
lkiran086 on Sun, 12 Feb 2017 12:08:52
Executed as user: IMPRX\SVC_SQL. Microsoft (R) SQL Server Execute Package Utility Version 10.50.2500.0 for 64-bit Copyright (C) Microsoft Corporation 2010. All rights reserved. Started: 1:41:35 AM Error: 2017-02-12 01:50:00.72 Code: 0xC002F210 Source: UPDATE EDC_BATCH_PROCESS,EDC_BATCH_PROCESS_DEPENDENCY & EDC_BATCH_PROCESS_DEL Execute SQL Task Description: Executing the query "DECLARE @BATCH INT SELECT @BATCH = ? UPDATE [dbo..." failed with the following error: "Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly. End Error Error: 2017-02-12 01:50:00.75 Code: 0xC002F304 Source: AUDIT_REPORT_STATUS_MAIL FOR_CDOMII_DY LINKED SERVER Send Mail Task Description: An error occurred with the following error message: "Failure sending mail. System.IO.IOException: Unable to read data from the transport connection: net_io_connectionclosed.". End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 1:41:35 AM Finished: 4:55:45 AM Elapsed: 11649.4 seconds. The package execution failed. The step failed.
Thanks
Replies
Mailson Santana on Thu, 16 Feb 2017 12:10:29
Hi,
Could you post the query (DECLARE @BATCH INT SELECT @BATCH = ? UPDATE [dbo...)?
If possible, also post the Parameter Mapping and Result Set settings