Recently I set up a new process to pull data out of a MySQL database and into SQL Server. Pretty standard ETL stuff, but it’s the organization’s first time moving data in this direction, so we had some extra work to do.
After installing the SSIS package and the MySQL .NET connector in the development environment, we went through a few rounds of “why isn’t this working? why isn’t that working?