How can i move data from sql server to snowflake using ssis.. and what all things to be considered and needed to perform this .

Mounika, Durgam 1 Reputation point
2023-09-29T01:52:41.6933333+00:00

Hi Team,

I am new to MSBI and snowflake, Please suggest me process.

How can i move data from sql server to snowflake using ssis.. and what all things to be considered and needed to perform this .

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
{count} votes

1 answer

Sort by: Most helpful
  1. AniyaTang-MSFT 12,446 Reputation points Microsoft Vendor
    2023-09-29T07:22:09.3333333+00:00

    Hi @Mounika, Durgam

    I found this link for you: https://www.cdata.com/kb/tech/snowflake-ssis-task-export-2008.rst, you can use it as a reference.

    If the answer is helpful, please click Accept Answer and Up-Vote for the same. If you have any questions, please feel free to let me know.

    Best regards,

    Aniya

    0 comments No 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.