SSIS - how to upload a file, process and archive it before loading next file

Question

Hello all,

I have several files to load to SQL server.

I need to load each file by itself, run additional tasks, archive it and only then move to the next file.

Using a foreach loop I can load the files but I don't understand how to execute another task on the table before loading the next file.

Is there any way to do that?

1. A data flow task to load txt file to DB table
2. Execute a SQL task on that table
3. Archive the file
4. Go back to step 1

Thank you for your help.

Answer 1

Hi @adi d,

You may consider using Foreach Loop Container.

Here is a blog with detail steps, you may have a check.

Move Multiple files using File System Task in SSIS

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.