SSIS: Windows batch Script with SSIS variables to ftp receive files

• sunil.mvs

  Ten Centuries

  Points: 1031

  More actions

  February 2, 2014 at 9:45 pm

  #396207

  hi

  Requirement: I need batch script to receive files from ftp to windows share drive .I need to pass ssis variables to batch script as Filename changes .

  Thanks

  Surya Sunil

• higgim

  SSCarpal Tunnel

  Points: 4090

  More actions

  February 3, 2014 at 3:58 am

  #1685423

  See attached image for how we do it (1):

  Script task to create the actual commands we want to run. (2)

  Output the content of variable to a text file (3)

  Run your ftp application using a Execute Process Task (4)