I have a variable set in my SSIS package called LastModified. I would like to use this in a SELECT in the Devart MySql Source component. Using the expression editor, I set the SELECT to:
SELECT * FROM Invoices WHERE LastModified > '<@user::LastModified>';
I have tried making the variable a DateTime and a String without any success. It seems as though it only passes the time portion of the variable through to the MySQL Server.
IF I hardcode the date it works as in
SELECT * FROM Invoices WHERE LastModified > '2021-01-01';
So, the question is, how do I go about using a DateTime variable and passing it into the Devart MySql Source component correctly?
Thanks,
Juan
How to use a DateTime Variable as Parameter in SSIS MySQL Source Component
Re: How to use a DateTime Variable as Parameter in SSIS MySQL Source Component
There is some issue with variables of type DateTime in the Data Flow Component. We are investigating it. We will notify you as soon as we have a fix.
As for now, I recommend using a String variable with values in the following format:
YYYY-MM-DD (Date only)
YYYY-MM-DD hh:mm (Date and Time)
It should work.