How to Import Data Into Snowflake From MS SQL Server via SSIS?
You will have to manipulate the data resides in multiple platform when you do the data analysis, machine learning, reporting, etc. We are going to discuss how to leverage Visual Studio to import data from MS SQL Server Into Snowflake.
Required Software/ Drivers:
1. Visual Studios 2019 Community edition
2. MS SQL Server ODBC driver
Steps:
- Once Visual Studio is downloaded and installed, Click on Extensions/ Manage Extensions / “Visual Studio Marketplace” under online section.
- Search for “integration” on right side search field, select “Microsoft SQL Server Integration Services Projects” and click on download.
3. Have ODBC set up for both MS SQL Server and Snowflake.
4. Create a project, search for “SSIS” and click on “Integration Services Project”.
5. In the project canvas, drag or double click on the “Data Flow Task”.
6. Under “Data Flow” tab, drag or double click on the “ODBC Source” and “ODBC Destination” from the “Common” section of SSIS Toolbox on the left panel.
7. Right click on “Connection Managers” on the right panel and select “New Connection Manager”. Select “ODBC“ and click add.
8. In the “Connection Manager”, select the items for Snowflake and MS SQL Server set up in Step 3.
9. Double click on the “ODBC Source”. In the “ODBC Source Editor”, select the item you set up for MS SQL Server. There are two ways to access to your source data:
a. Table name: select the target source table or view.
b. SQL command: write a SELECT SQL query to get data.
You can preview your data to ensure everything looks good.
10. Double click on the “ODBC Destination”. In the “ODBC Source Editor”, select the item you set up for Snowflake. You have to select the target table to receive data from the source.
11. Connect “ODBC Source” with ODBC Destination by dragging the Blue arrow. In the “Mappings” of “ODBC Destination”, make sure all columns are aligned between source and destination.
12. Click on the “Start” to run.
Here are some other our articles for data import & flow across the platforms. Take a look if you are interested in these topics.
Python
- How to Import Data into Teradata via Python?
- How to Import Data into Snowflake via Python?
- How to Import data into SQLite via Python Part 1 (Json file/ MS Excel/ MS Access) ?
R
JavaScript
- How to Import Data into MS SQL Server via JavaScript Node JS (Part 1: csv & Excel)?
- How to Import Data into Snowflake via JavaScript Node JS (Part 1: csv & Excel)?
