Snowflake to SSIS

[hemanth4]

I am getting this error "indicator pointer is required by the driver to indicate null output data" while I am importing data from Snowflake to SQL server using SSIS. I have created an ODBC driver connection in order to access it. I am able to do it for some of the views but unfortunately for 1 of the view it is throwing me this error

 

[RetroGamerChile]

This error often arises when the ODBC driver attempts to fetch a NULL value without an indicator pointer to signal the NULL. To resolve this, check if the target table in Snowflake has NOT NULL constraints and adjust your SSIS data flow accordingly. Use a derived column task to replace NULL values or use IFNULL in your query to handle NULLs. Iteratively test to pinpoint the problematic column or row causing the error.