All,

I'm new to SSIS and really need you guys’ help. Here is my problem.

I need to copy data from number of tables to the staging tables in a DB,
These are just direct copy and doesn’t need any changes during the
extraction. The process basically copy each of source table to their staging
table (i.e source_table1 to Stage_table1) and need to use the table’s name to
get other information( calling procedures with the table name).

Question 1: How to copy group of tables? Create different data flows for
each table or is there a way to use one data flow to copy all the tables?
Question 2: How to get the table name and to use it as variable in the
data/comtrol flow?
Question 3: What’s the transformation should I use to add a new field? (ie,
source table has 2 fields and the target table has 3 fields, during the
transformation process I need to give the target field a value)

Thanks a lot
Jessie

Hello Jessie,


Lots of questions

You cannot create a one stop data flow task and auto redo the mappings in
SSIS so you should implement either 1 data flow per table or one data flow
with many pipelines within

How do you get the tablename? The problem here is that no pipeline component
knows anything about any of the other components. I would add variables
and have their values be the names of the tables.

How do you create a column that does not exist? Have a look at the derived
column transform


Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com