SSIS Foreach Loop Not archiving files

• mattdarvellwow

  SSC Veteran

  Points: 268

  More actions

  December 4, 2017 at 9:49 am

  #324883

  Good afternoon,

  I am having some problems with a foreach loop container within SSIS.

  This is the current setup:

  1. SQL Task to get parameters from a SQL table.
  2. Foreach loop container
  3. Script task within Foreach loop container which uses C# to archive files into folders which are specified within the parameters sourced from the SQL task to begin with.

  The problem:

  We load data from multiple folders for certain dataflows. In this scenario, only the first row parameter returned from the SQL task is being used. After that particular file has been archived off, I want the foreach loop to then proceed into the next folder, archive, then onto the next, archive etc until it is complete.

  I have setup the Foreach File Enumerator how I thought was correct: Collection > Expressions > Directory - This is set by a variable which is collected from the SQL task.

  Any help would be greatly appreciated, as I am having a bit of trouble proceeding with this right now.

  Cheers.

• Phil Parkin

  SSC Guru

  Points: 247158

  More actions

  December 4, 2017 at 9:54 am

  #1970559

  Can you paste the code from your script task?

  ---