Devart Forums

Posted: **Mon 20 Nov 2017 18:51**

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.

Posted: **Fri 24 Nov 2017 14:15**

Try using in the query the following syntax :

Code: Select all

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

Devart Forums

Salesforce Date literals in SSIS

Salesforce Date literals in SSIS

Re: Salesforce Date literals in SSIS