Need Help How to over come this error while running SSIS Job .

Category: sql server notification


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.



Mailson Santana on Thu, 16 Feb 2017 12:10:29


Could you post the query (DECLARE @BATCH INT  SELECT @BATCH  = ?    UPDATE [dbo...)?

If possible, also post the Parameter Mapping and Result Set settings