These are deadlocks caused by your SQL query. Please modify your SQL queries using "with (NOLOCK)" to avoid deadlocks.

There is nothing to do with SSIS packages.