Forum Discussion
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.
The component is missing, not registered, not upgradeable, or missing required interfaces. The contact information for this component is "ODBC Destination;Microsoft Corporation; Microsoft SQL Server; (C) Microsoft Corporation; All Rights Reserved; http://www.microsoft.com/sql/support;1".
Can we use snowflake ODBC destination in the standard edition or what possibly could be the issue.
Regards
--Harvinder