I am learning SSIS (Visual Studio 13, SSDT). I plan to populate a SQL Server database on my local machine with tables from a remote MySQL server.
I connected to the MySQL server using an ODBC connection and successfully created and populated a single named table on my local MSSQL database (OLE DB connection).
So far so good. Now I want to iterate thru all the MySQL tables in the source database and do the same. How would I do that?