question

kumarkiran avatar image
kumarkiran asked

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

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
sql-server-2008sqlssissql-server-2008-r2
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

· Write an Answer

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.