For Each Loop - Move to next file
-
Hi All,
I have a for each loop to pick up excel files in a directory. The loop has a data flow task then a file system task to move the files in to a archive folder. If I disable the file task it loops through all the files and the data flow loads all the files. When the file task is enabled it moves the first file and then fails to make a connection to the next file.
Variables:
@foldersource, String = C:\DSM Excel Files\Healthcare logictics\
@filename, String =
For Loop:expression for the directory, @foldersource and variable is mappings, @filename index 0.
Excel connection: excel expression excel file path, @filename
delay validation is true for data flow task and validate external metadata is false for the excel source.Screen shots are attached.
-
Once I change the loop retrieve file name to fully qualified it loads the file but the file task doesn't work.
-
Can you post your file system task. Also, are you getting any errors?
-
this is the file task
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply