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 jha
Vipin 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 MVP
http://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