Salesforce Date literals in SSIS

[[email protected]]

I am trying to configure ODBC data flow component in SSIS using the devart Salesforce odbc connector. Is there a way to include OSQL date literals in the SQL command text where clause? I am trying to use Where date__c = Today, which is valid OSQL text.

[MaximG]

Try using in the query the following syntax :

Code: Select all

... Where date__c = Date('now')