My SSIS fails most of the time with the following error; words sometimes without any issues.
How do I get it work each time without errors?
Message
Microsoft (R) SQL Server Execute Package Utility
Version 10.0.1600.22 for 32-bit
Copyright (C) Microsoft Corp 1984-2005. All rights reserved.
Started: 8:51:11 AM
Error: 2021-07-29 09:08:51.01
Code: 0xC002F210
Source: Update ProductTable Execute SQL Task
Description: Executing the query "
SET TEXTSIZE 0
DECLARE @PK char(50), @date1 date..." failed with the following error: "Transaction (Process ID 62) was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
End Error
DTExec: The package execution returned DTSER_FAILURE (1).
Started: 8:51:11 AM
Finished: 9:08:51 AM
Elapsed: 1059.86 seconds