Call Snowflake Stored Procedure using SSIS Execute SQL Task

• wk

  SSC Enthusiast

  Points: 112

  More actions

  March 12, 2025 at 5:36 am

  #4557632

  Hi I am getting the below error when trying to call a Snowflake stored procedure in SSIS 2017 using Execute SQL Task.

  Any ideas on how to resolve it. I have confirmed the procedure works when calling from a Snowflake Worksheet.

  Error: 0xC002F210 at Execute SQL Task, Execute SQL Task: Executing the query "call procedure_name." failed with the following error: "[Snowflake][ODBC] (10690) Expected descriptor record does not exist during query execution.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.

  Task failed: Execute SQL Task

  Warning: 0x80019002 at Package: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED.  The Execution method succeeded, but the number of errors raised (1) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.

   

• Phil Parkin

  SSC Guru

  Points: 247158

  More actions

  March 12, 2025 at 9:27 am

  #4557750

  This may be relevant:

  https://community.fabric.microsoft.com/t5/Power-Query/ODBC-ERROR-07002-Snowflake-ODBC-10690-Expected-descriptor-record/td-p/3194442

  Perhaps try making the proc very simple and seeing whether the error goes away. If it does, you will know that the problem relates (somehow) to proc complexity.

  ---