Does anyone know if it is possible to use SSIS with Amazon RDS? Since RDS is essentially MySQL - is this possible using OLE DB or something else ??
Amazon RDS offers full support for all MySQL features except replication. Therefore, you can use OLE DB or any other driver to access MySQL from your application.
I would recommend you use the MySQL ODBC driver in conjunction with the Source ADO.NET component. The ODBC provider is the most stable.
Source: https://habr.com/ru/post/1300123/More articles:Show line numbers in Visual SlickEdit - slickeditDecision to support species in single-project areas - c #Show ASCII character - rC # dll not found - c #How long does it take to create a new SQL database connection - c #Several try-excepts followed by Else in python - pythonget id of created record in SQLAlchemy - pythonSQL Server - select all items with a date in the previous month - sqlUser authentication using XMLHttpRequest works in IE and not in Chrome? - authenticationParallel processing in Scala - performanceAll Articles