Post reply

Passing a directory and filename variable to a for each loop

  • March 8, 2010 at 2:50 pm

    #139273

    I'm trying to move files from one folder to another at the end of several different processes. I want to use a generic SSIS package, but I'm not sure how to pass the directory and file name variable to the foreach loop. I'm currently using the directory and name properties, but do I leave the folder: and files: under the enumerator configuration blank or do I add the variable names to the directory and files dialogue?

  • March 8, 2010 at 3:27 pm

    #1130322

    Phil Church (3/8/2010)

    I'm trying to move files from one folder to another at the end of several different processes. I want to use a generic SSIS package, but I'm not sure how to pass the directory and file name variable to the foreach loop. I'm currently using the directory and name properties, but do I leave the folder: and files: under the enumerator configuration blank or do I add the variable names to the directory and files dialogue?

    under the enumerator configuration The folder is the directory property and Files is the file spec property. These can be setup with your variables in the expressions section and yes just leave the folder and files blank.

    hth - tom

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

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