Where are you trying to add this statement?

You might try setting DelayValidation/ValidateExternalMetadata to True/False on your Source.

The Derived Column transform is not a place for building queries - it is a place for adding new columns to your dataflow which can then be used later to...

Look into using VariableDispenser - you will be able to update your variables in the pipeline of the Script Component if you use that, rather than the Read Write variables...

Put your dataflow in a Foreach container ...

1) Yes

2) Add a Derived Column transformation between your source and destination and assign these items to new columns which can then be used further along your dataflow to INSERT...

Create a Dataflow. In the Dataflow pane, create source and destination components and link them. Create a mapping from source to destination and then you can run the package.

Why not use a single Foreach loop to do the entire load/archive process?

This seems to delete files, not folders ...

Please post the code fragment which is causing the error and the text of the error message.

I was obviously in a 'read English, not code' mood when I responded, because I didn't even look at your DDL. Now that I have, I see that we were...

Thanks for the feedback, glad to have helped.

--deleted

Expanding on this idea,...

I just tried it and it worked as I suggested.

Against the properties for your flat file source, have you got 'retain nulls' set to true?