Share via

how to connect Sql server integration services to Amazon redshift datasource

Greg Booth 1,371 Reputation points
2021-08-03T15:35:08.087+00:00

We are using SQL server integration services.
We need to connect to Amazon redshift as a data source.
What is the best way to connect SSIS to amazon redshift ?

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,702 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. ZoeHui-MSFT 41,491 Reputation points
    2021-08-04T01:48:20.89+00:00

    Hi @Greg Booth ,

    I did some online research for you that I did not find a directly way to connect to Amazon redshift.

    There are many third-party plug-ins which could achieve your requirement, please refer to them carefully.

    Regards，

    Zoe

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

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
    Hot issues October

    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.