We can load the SQL server table data into the SNOWFLAKE using SSIS. To load the data we are using the ODBC destination to connect the SNOWFLAKE and loading it.
Before
creating the package we need to create the ODBC DSN.
Read here: Creating
ODBC Connection for the SNOWFLAKE
Taking Data flow task in SSIS.
Now taking ODEDB Source to get the data from the SQL server table.
Now taking ODBC Destination.
Before that we are creating the ODBC connection.
Right click on the connection manager pan
Click on the new connection and
select the ODBC Connection and click on the add button.
Read here: Creating ODBC
Connection for the SNOWFLAKE
https://bageshkumarbagi-msbi.blogspot.com/2022/09/creating-odbc-connection-for-snowflake.html
Select the DSN name and provide the SNOWFLAKE User name and password and click on the Test Connection button to test the connection.
Click Ok. ODBC Connection is
created successfully.
Now taking Destination as ODBC destination and selecting connect as ODBC.
Providing the table name
Doing the column mapping.
Click ok.
Our package is ready to run.
See the source data.
Now running the package.
Package executed successfully.
Now see the records into the SNOWFLAKE table.
1k rows loaded successfully.
