Using parameter Today in SSIS package - Source Salesforce

[Gaetan]

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)

[Shalex]

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:

Code: Select all

select * from MyTable where LastModifiedDate='<@User::TODAY>'

[Gaetan]

Thanks a lot