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?