Salesforce Date literals in SSIS

Discussion of open issues, suggestions and bugs regarding usage of ODBC Drivers
Post Reply
dba@mowctx.org
Posts: 1
Joined: Mon 20 Nov 2017 18:40

Salesforce Date literals in SSIS

Post by dba@mowctx.org » 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.

MaximG
Devart Team
Posts: 1030
Joined: Mon 06 Jul 2015 11:34

Re: Salesforce Date literals in SSIS

Post by MaximG » Fri 24 Nov 2017 14:15

Try using in the query the following syntax :

Code: Select all

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

Post Reply