SSIS Redshift Execute SQL Task

SSIS Redshift Execute SQL Task

SSIS Redshift Execute SQL Task can be used to send any sql queries to Redshift Cluster without needing ODBC driver. You can Issue various sql commands such as DROP, COPY, UNLOAD, CREATE etc.

  • Allows to execute queries against Amazon Redshift Cluster without ODBC driver
  • Load query at runtime from variable, file or Direct value
  • 100% Managed code means its 32bit and 64bit compatible
  • You can issue COPY, UNLOAD commands very easily
  • Support for SQL Server 2019, 2017, 2016, 2014, 2012 (32/64 bit) and now Azure Data Factory
  • Articles/Tutorials: Amazon Redshift related articles

Download Help File Buy
View All Tasks Like This
ScreenshotsArticles / Useful LinksSystem Requirements
Create new Amazon Redshift Connection in SSIS

Create new Amazon Redshift Connection in SSIS

 

Execute Redshift SQL query in SSIS

Execute Redshift SQL query in SSIS

See Also

Articles/Posts

Amazon Redshift

MySQL to Redshift Data Load Using SSIS

Contents1 Introduction – MySQL to Redshift Load2 Video Tutorial3 Right way but hard way3.1 Steps for Amazon Redshift Data Load from On-Premise files or RDBMS (e.g. MySQL, SQL Server)4 Doing it easy way4.1 Should I use SSIS to load Redshift Database?4.2 Command line approach for MySQL to Redshift data loading5 Setup your Amazon Redshift Cluster6 […]

1 comment

References

Click here to learn more about System Requirements
Download View All Tasks Like This