You obviously need to create a job to run the package before trying that idea ... it should work.

I think I know what you've done. Your destination cannot have more than one input.

You need to delete the mapping from source to destination. Then add source to derived column...

If you can use CSV...

It's simple to do this - add a Derived Column transformation with one new column and set its value to "X".

Now map this new column to your destination column as...

Great, thanks for posting back.

Maybe it's set by an Expression. Check the Expressions/Package Name property.

You don't need a Script task for that - use a Derived Column instead.

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?