pass args from for each loop to execute process task

• subhabrata.bhattacharjee

  SSC Journeyman

  Points: 79

  More actions

  April 25, 2011 at 5:17 am

  #249331

  hi,

  i am a newbee to SSIS. i created a a for-each file loop which runs through the folder c:\test. in this folder i have multiple files which need to be processed. for this, i added a Execute process task inside the loop container and i am calling vb .exe file which does the processing of the files one by one.

  what i need to do is to pass the current filename in the Loop as an argument to the execute process task such that the vb .exe file receives the filename as a command line argument and processes the file.

  i tried putting the filename variable in the Argument option of Execute Process task. also tried selecting the filename as Input Parameter. But still not working. please help

• Orlando Colamatteo

  SSC Guru

  Points: 182293

  More actions

  April 25, 2011 at 3:30 pm

  #1315617

  This video demos the ForEach Loop container in SSIS which may be able to help you to arrive at a solution:

  http://www.sqlshare.com/looping-through-and-loading-files-with-ssis_34.aspx?searchid=155499

  There are no special teachers of virtue, because virtue is taught by the whole community.
  --Plato