First you need to install SnowflakeDSIIDriver and set up an ODBC data source. You can find more details about the driver and the connection details here https://docs.snowflake.com/en/user-guide/odbc-windows.html
Use ODBC source in SSIS package.
If you find any performance issues due to most of the fields are in "DT_TEXT", then use CASE statement to convert as VARCHAR in SQL command.
Cheers!
Uma
No comments:
Post a Comment