dan-572483 (11/13/2013)
What is the best approach for extracting data from a MySQL Database and importing it into MSSQL? 1) export to text file then import, 2) Set up ODBC conneciton to the MySQL server as a Connection Manager item - can you specify a query in a dataflow task that is correct for MySQL but won't run in MSSQL? or 3) Some other way?
Your option (2) is correct also. Whether the source query runs OK on SQL Server is not relevant if your connection is to MySQL.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.