Post reply

SSIS Foreach Loop Not archiving files

  • 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.

  • December 4, 2017 at 9:54 am

    #1970559

    Can you paste the code from your script task?

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply