Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
maevr
Posting Yak Master
169 Posts |
 Posted - 2007-08-20 : 02:57:16
|
| I have an Oracle 10G database with some tables that I want to load into my SQL 2005 database every night (Datawarehouse). The tables may change(add columns) and this could be done in SQL 2000 DTS by writing a script as transformation. How can I do this in SSIS? |
|
|
mwjdavidson
Aged Yak Warrior
735 Posts |
Posted - 2007-08-29 : 04:09:58
|
| Okay, since no one else is biting... I think you're going to struggle to do this with SSIS. It's not that common a data warehousing requirement to populate tables with unknown / dynamic structures. What is the purpose of the SQL 2005 'Datawarehouse'? Most reporting tools are going to struggle in a similar fashion if the schema is constantly changing.Mark |
 |
|
|
|
|
|
Copy dynamic table?