I am working on Oracle to SQL migration. SQl DB was having very different design than the oracle so i decided to import data using the SSIS to a staging DB in the same instance.
Now i want to proceed and want to put data in the real DB and planning to use SSIS
But I do not have clue where Should the columns go.
based on that I have two Questions
Q:1) How can i know that where the data from one table go? I mean Do i need to work with Application Developers from both legacy oracle and new SQL side ?
Q:2) How Shd i Use the SSIS now i mwan which tasks?
Please guide me ASAP
Thanks in advance
View Complete Post