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 |
|
janechoo
Starting Member
16 Posts |
 Posted - 2009-06-11 : 03:25:52
|
| Hi, AllAnyone can help to solve my problem? recently my company just install new SQL server 2008, i try to create SSIS which is download a data from IBM DB2 to SQL database, but it take a longer time to complete a task, my data has about 1 mil plus and normally take about 20 minutes to complete in SQL server 2000. but in SQL Server 2008, it take a two hours to complete, anything i have not yet install and i install not in proper way? thanksJane |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-06-11 : 13:06:46
|
| do you notice any difference in index,statistics,... between 2000 and 2008 destination table? |
 |
|
|
janechoo
Starting Member
16 Posts |
Posted - 2009-06-11 : 19:18:21
|
| both tables also without any indexes. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-06-14 : 04:25:37
|
| are there any difference in server configurations b/w sql 2008 & sql 2000 boxes? |
|
|
|
janechoo
Starting Member
16 Posts |
Posted - 2009-06-16 : 20:00:00
|
| sql2008 server spec is better than sql server 2000. one thing i'm not sure is how to download the data from IBM db2? what type of data source need to be use? |
|
|
|
cat_jesus
Aged Yak Warrior
547 Posts |
Posted - 2009-06-23 : 13:51:55
|
| We use linked servers for our IBM db2 downloads. That way we can just use stored procedures.An infinite universe is the ultimate cartesian product. |
|
|
|
|
|
|
SSIS