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 |
|
vipinjha
Starting Member
21 Posts |
 Posted - 2012-02-29 : 03:38:21
|
| Dear All,I am facing a problem in loading data from Oracle server to sql server using ssis package .i am working on banking domain.i ma fetching 10 Million from oracle to sql server using ssis which is taking 1 hr or more.please advise me some good way to load.thankx ,Vipin jhaVipin jha |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-02-29 : 12:09:22
|
| can you give a high level description on current packages task you've used?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
rajarajan
Starting Member
48 Posts |
Posted - 2012-03-15 : 12:39:43
|
| is your package loading the data by truncating table data and load the data ? |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
|
|
|
DATA LOD FROM ORACLE TO SQL