Salesforce source object filter variable

[don...@gmail.com]

Hello,

I'm creating a daily ETL job that will get modified records from a Salesforce table.

In the Component Properties of Salesforce Source, I want to use InputType as Object so I don't need to list all the 400+ columns of the table.

Then on the ObjectFilter column I want to do something like:

SystemModstamp > @ModTimeStamp

where @ModTimeStamp is a variable that will change for each run-time.

I'm getting a syntax error for this for SOQL. What are the options for me to accomplish this?

Appreciate any help!

[Ivan Peev]

Hi Dona,

You have to setup SSIS expression to modify the ObjectFilter parameter at runtime. I would recommend you check the "Dynamic Query" demo video from the documentation page here.