| Jessie 2006-02-09, 9:23 am |
| 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
|