At the moment I have an SSIS 2008 R2 package, with a SQL task that will occasionally return no rows. When this happens the package throws an error
[Execute SQL Task] Error: Executing the query "exec ssisMyProc ?, ?
" failed with the following error: "The statement has been terminated.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
FailPackageOnError is set to False.
Question: Is there a way to handle this scenario without it throwing an error?
Thanks in advance.