Hello,
I would like to use the parameter "TODAY" in SOQL statement with SSIS but it doesn't work.
Example:
select * from MyTable where LastModifiedDate=TODAY
I have the following error : Unknown column 'TODAY'
Is there a solution in order to filter data on the current day? (i'm using the Devart Salesforce Connection Manager - SSIS)
Using parameter Today in SSIS package - Source Salesforce
Re: Using parameter Today in SSIS package - Source Salesforce
You are using the Devart Salesforce Source component, aren't you?
Please define your parameter (for example, with the GETDATE() expression) via SSIS > Variables menu of Visual Studio. After this, you can use newly created parameter in the query:
Please define your parameter (for example, with the GETDATE() expression) via SSIS > Variables menu of Visual Studio. After this, you can use newly created parameter in the query:
Code: Select all
select * from MyTable where LastModifiedDate='<@User::TODAY>'