Im trying to create a dynamic data flow task to do the following.

I have set of views in schema "a" and a set of corresponding tables in
schema "b". Corresponding tables and views have the same name and are exact
clones in structure to the view they correspond to. Im trying to create
something using SSIS to, copy the data from the views in schema "a" to the
tables in schema "b"(possibly a loop).

This cannot be explicitly done as the views are dynamically generated so
there can be any number of them. I have taken care of creating the tables in
schema "b" to correspond to the views in schema "a" but i just need to move
the data.

The problem im running into at the minute is that on creating a data flow
task, when specifying the source and destination, if if choose the loop
variable containing the view/table name: this has not been assigned yet so
SSIS cant see it as a table/view and it fails.

Any tips would be much appreciated.

Thanks
Gerard