March 5, 2021 at 12:05 pm
Hi there, everyone.
We've create and SSIS package that gets data from a Snowflake database via an ODBC source which then populates a SQL OLE DB destination table. This happens within a work flow task. When we run it from within Visual Studio everything runs perfectly, yet when we schedule it as a SQL Server Agent job it fails with:
Data Flow Task:Error: SQLSTATE: 22002, Message: [Snowflake][ODBC](10450) Indicator pointer is required by the driver to indicate NULL output data, but is not provided.;
We've searched far and wide and tried a few things, but nothing has worked so far. Has anyone else come across this? Does anyone know what this means or how we could solve this?
March 5, 2021 at 2:05 pm
The error is coming from the Snowflake ODBC connector. I would check that it is configured the same on the server where SQL is hosted and on your visual studio machine. Failing that, I'd reach out to the snowflake folks as the problem is coming from the Snowflake side, not the SQL Server side.
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
March 5, 2021 at 6:47 pm
Thank you for your response! I think I’ll have to get hold of the Snowflake folks it seems.
June 1, 2021 at 11:38 pm
Did you ever find a resolution to this error?
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply