Exception has been thrown by the target of an invocation in execute sql task

• Griffster

  SSCertifiable

  Points: 7097

  More actions

  April 16, 2012 at 6:35 am

  #146895

  I keep on getting:

  "Error: 0xC002F210 at Get the row writes etc, Execute SQL Task: Executing the query "dbo.sp_GetSSISPackageLog" failed with the following error: "Exception has been thrown by the target of an invocation.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly."

  in my execute sql task. I use an ADO.NET connection type and the SQL statement is set to the name of my stored procedure (sp_GetSSISPackageLog) with an XML result set. My stored procedure takes in a GUID value which is effectively the execution instance of the SSIS package.

  In parameter mappings, I have Variable Name = System::ExecutionInstanceGUID, Direction = Input, Data type = guid, Parameter Name = @executionid, data type = guid, Parameter name = @executionid (the parameter name in my stored procedure and Parameter Size = -1

  My Result Set pane has a mapping from Result Name 0 to Variable Name User::v_EmailXML which is a string variable.

  Not sure which item is causing the problem. Tested the connection in the data source and that seems fine so I'm at a loss as to what's causing this error. Anyone able to help please?