Devart Forums

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

jpsignups wrote: ↑Fri 15 Jan 2021 03:01 I have tried making the variable a DateTime and a String without any success.

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.