What are the steps to check before we migrate Tables from sql server to snowflake using ssis and what is the process to migrate ??

Mounika, Durgam 1 Reputation point
2023-09-26T22:34:15.4733333+00:00

What are the steps to check before we migrate Tables from sql server to snowflake using ssis and what is the process to migrate ??

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,788 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,577 questions
SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
532 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. ZoeHui-MSFT 36,511 Reputation points
    2023-09-27T05:55:47.1733333+00:00

    Hi @Mounika, Durgam,

    You may use ODBC driver to connect to snowflake destination.

    steps to check before we migrate Tables

    Make sure that you have set the destination tables to load the data.

    Here is a similar tutorial which is loading data from snowflake to sql server, you may take a reference to.

    ingect data from snowflake to sql by using ssis

    Regards，

    Zoe Hui

    If the answer is helpful, please click "Accept Answer" and upvote it.

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.