Executing the query "%1!s!" failed with the following error: "%2!s!". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly. Happens when the task is not configure correctly (ResultSet property or parameter types are incorrect), or if there is a problem executing the query.

Community Notes

The way to fix this problem: Change your SQL Task (normally a query) to a Stored Procedure. In the options of the SQL Task, change "IsStoredProcedure" to "True". This fixed my problem! (AcidBurn)

TaskErrorCodes