asked on

Need LoopForEach function for SSIS to Archive processed files

Ok, lots of progress on the last solution. I have the flow working now properly. I am pulling multiple flatfiles from ftp, processing them, appending them to table in db. Now I need to archive all the files that are processed with a FOREACH LOOP CONTAINER. This is where I am stuck.

I have searched various things and have not found a working solution yet. Any assistance is most appreciated.

Here is a diagram of the working flow.

ASKER CERTIFIED SOLUTION

Barry Cunney

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Barry Cunney

In the FileEnumerator specify the folder in where the files to be archived exist

In the File System Task specifiy the Destination to where the files should be archived

pskeens

ASKER

Ok, I have the FOREACH lOOP CONTAINER setup. The job works all the way through without errors, however the files do not get moved to the Archived Folder.

Here is an image of the current flow:

I got this warning even though it executed:

"Warning: The For Each File enumerator is empty. The For Each File enumerator did not find any files that matched the file pattern, or the specified directory was empty."

pskeens

ASKER

GOT IT! I just went back and checked all the variable paths again and it started working. I must have had an extra space or dash in the qualifier perhaps.

Thanks for the assistance!!