Home Forums SQL Server 2012 SQL 2012 - General Help with passing FLEE expression into SSIS user variable RE: Help with passing FLEE expression into SSIS user variable

  • February 5, 2018 at 2:00 am

    #1978511

    BeatleBoy - Monday, January 29, 2018 9:28 AM

    Hello,

    Thanks for the reply.

    There is no error message - the result is merely that the variable value is set to the unexpected value of Modifiedtime "and" Name.EndsWith(".txt") rather than Modifiedtime > Now.AddDays(-1) and Name.EndsWith(".txt")

    I didn't do a for each because it seemed more efficient to just pass the filter value and not have to add the extra logic to filter in SSIS and let the SFTP module only return the relevant files.

    Basically while designing SSIS packages we use variables within the scope of SSIS package and deploy the package to File system / SQL server / Package store /  Catalog. Please could you explain why you had provided / set up the variable value into the job "Set Values" configuration tab ?

    Alternatively you can declare your variables within SSIS and get the package to deployed to SQL Server. Hope this can help you ? Anything else, Kindly revert back.