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

Question

Mounika, Durgam 1

Hung-Chun Yu 981 Reputation points Microsoft Employee Moderator

2023-09-27T07:03:11.5933333+00:00

@Durgam Mounica Thank you for contacting SQL Server Protocol Support. Looking at the post, it appeared your question is not Protocol related outlined in the https://aka.ms/openspecs. I removed [SQL Server Open Specifications] tag from the post.

1 answer

Hung-Chun Yu 981 Reputation points Microsoft Employee Moderator

2023-09-27T07:03:11.5933333+00:00

@Durgam Mounica Thank you for contacting SQL Server Protocol Support. Looking at the post, it appeared your question is not Protocol related outlined in the https://aka.ms/openspecs. I removed [SQL Server Open Specifications] tag from the post.

Answer 1

ZoeHui-MSFT 41,496

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.

Regards，

Zoe Hui

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