I'm studying SSIS packaging and sending data between Microsoft SQL Server and MySQL and currently getting this error:

This is my query:

SELECT umLastName, umFirstName FROM TestTable WHERE umCBUnlocatable = 1 AND umFirstName ' ' AND umLastName ' ';

I am setting this query in the Source but i am getting the error on the destination portion of the package, Do you know why this is? i can't see any errors in my query.

Microsoft Visual Studio ERROR [42000] [MySQL][ODBC 5.3(a) Driver][mysqld-5.6.23-cll-lve]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near wpif_ccdp" at line 1 CXK