Go Ad-Free on CAclubindia with Daily Mobile Updates. Subscribe Now!

Snowflake to SSIS

07 March 2024

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

Reply
Follow
Share

1 Replies

Yasaswi Gomes new (Finance ) (4514 Points)
Replied 07 March 2024

Did you not get the Stackoverflow answer? Ive done some AI research, it might help

The error message you’re encountering, “Indicator pointer is required by the driver to indicate null output data,” typically occurs when you’re trying to retrieve a NULL value from the database without providing a means for the ODBC driver to identify that the data is, in fact, NULL ¹. Let’s explore some potential solutions:

Check Target Table Constraints:
- Verify whether the target table in Snowflake has any NOT NULL constraints on its columns. If so, ensure that you’re not attempting to insert NULL values from your SQL Server view. Adjust your data transformation logic accordingly.
Iteratively Identify the Issue:
- It might be necessary to iteratively work out which column(s) or rows are causing the issue.
- Select a limited set of columns and iterate until you identify the specific column causing the problem.
- Try IfNULL Function
ODBC Driver Configuration:
- Sometimes, the issue could be related to the ODBC driver configuration.
- Follow these steps to resolve the issue:
  - Log in to a Windows machine.
  - Click Start, then click Run, type regedit in the Open box, and click OK.
  - Navigate to HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\Your_Snowflake_DSN.
Workaround Parameter on MSSQL Server:
- If you’re connecting to Snowflake via a linked server in SQL Server, consider configuring the workaround parameter on the remote MSSQL server’s ODBC driver installation (not the local one where SSMS is installed).
- Open Regedit as an Administrator on the MSSQL host.
- Navigate to HKEY_LOCAL_MACHINE > Software > ODBC > ODBC.INI > <DNS_name_identified_in_step2>.

Remember to adapt these solutions based on your specific scenario, and test thoroughly to ensure successful data import from Snowflake to SQL Server using SSIS. 🚀