Post reply

Call Snowflake Stored Procedure using SSIS Execute SQL Task

  • 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.

     

  • 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.

Viewing 0 posts

You must be logged in to reply to this topic. Login to reply