I\'m studying SSIS packaging and sending data between Microsoft SQL Server and M
ID: 3733923 • Letter: I
Question
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 CXKExplanation / Answer
Looking at your query it seems like you are checking condition that firstName and lastName shouldn't be null. You should use this one.
SELECT umLastName, umFirstName
FROM TestTable
WHERE umCBUnlocatable = 1
AND umFirstName is not null
AND umLastName is not null;