File Transfer Task. Remote Filter issue

[eric.r...@gmail.com]

Hello,

When using File Transfer Task to receive files, I want to set the Remote Filter to receive files whose name contains current date, e.g. PaidChargebacks_2018_05_29.csv

Created a variable calcDate with value "_2018_05_29.csv"

Created another variable called RemoteFilter with expression "Name.StartsWith( \"PaidChargebacks" +  @[User::calcDate] + "\")"

that evaluates to:  Name.StartsWith( "PaidChargebacks_2018_5_29.csv")

I used this in the RemoteFilter as shown in the attached pic and it fails on the syntax

Thanks

[Ivan Peev]

H Eric,

 The filter should not contain any reference to SSIS variables. You have to construct SSIS expression which creates the text definition of the Filter.

[eric.r...@gmail.com]

Hi Ivan,

Sorry, not sure what you mean. Can you please elaborate?

[Ivan Peev]

Eric,

Do not configure Filter parameter which references SSIS variable. Construct and SSIS expression which builds the text for the Filter parameter.