Fsb
2010-01-21 20:21:54 UTC
Best approach to import tables.
I have the following databases
1. Current (only hold current month)
2. Archive
Each of these databases has the following tables;
1. Transaction Header
2. Transaction Line
3. Merch details
4. Return details
Now the header table is the only table that has transaction date in it. I
need to import a date range of data (that may be bigger than the current
month, so I need to pull from both tables). So I would need to query the
header table for a date range, get the transaction Id's and use them in all
other tables to get its data.
What is the most effect way of getting this data using SSIS 2008. I was
thinking of creating some sort of cache tables(if it possible) that holds
the transaction ID's from the header then somehow join this table of
transaction ID's with ALL tables so they can all load at the same time. Am I
on the right path?
I have the following databases
1. Current (only hold current month)
2. Archive
Each of these databases has the following tables;
1. Transaction Header
2. Transaction Line
3. Merch details
4. Return details
Now the header table is the only table that has transaction date in it. I
need to import a date range of data (that may be bigger than the current
month, so I need to pull from both tables). So I would need to query the
header table for a date range, get the transaction Id's and use them in all
other tables to get its data.
What is the most effect way of getting this data using SSIS 2008. I was
thinking of creating some sort of cache tables(if it possible) that holds
the transaction ID's from the header then somehow join this table of
transaction ID's with ALL tables so they can all load at the same time. Am I
on the right path?