SSIS from SQL Server to Snowflake not working from sql server agent or DTEXEC
Hi,
We are setting up SSIS package to move data from SQL Server 2022 standard edition to Snowflake (64 bit odbc driver) and it works fine from Visual Studio but getting following error when running from agent or command line:
The component metadata for “ODBC Destination, clsid {C1463F00-2FAF-4AD4-A212-C9D9CCB54575}” could not be upgraded to the newer version of the component. The PerformUpgrade method failed.
Can we use snowflake ODBC destination in the standard edition or what possibly could be the issue.
Regards
–Harvinder
Hi, We are setting up SSIS package to move data from SQL Server 2022 standard edition to Snowflake (64 bit odbc driver) and it works fine from Visual Studio but getting following error when running from agent or command line: The component metadata for “ODBC Destination, clsid {C1463F00-2FAF-4AD4-A212-C9D9CCB54575}” could not be upgraded to the newer version of the component. The PerformUpgrade method failed. Can we use snowflake ODBC destination in the standard edition or what possibly could be the issue. Regards–Harvinder Read More