*you should view in 720p
I have a SSIS 2005 (sp2) package with some Execute SQL Tasks that have become corrupt. When executed, the package fails on these tasks with the following error message"
"failed with the following error: "Syntax error or access violation". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
Task failed: Create yearly opening balances"
The only work around is to re-create the task.
Link to this comment:
All Comments (0)