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 |
|
ricky_newbee
Posting Yak Master
126 Posts |
 Posted - 2006-01-20 : 15:51:56
|
| Hi, I have a situation here when i am copying SQL 6.5 table data over to SQL 2000. I have a table with 18 Million rows. I have created a table and ran DTS Tansform data task and it ran for 1 hour. It looks like it has finished copying data( staus on Executing Package screen says it has 18 Million rows has been copied). It doesn't just say it has finished. Its almost been another hour since it has been like that. Any ideas?Thanks,Rick |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2006-01-20 : 15:58:52
|
| It is probably still inserting the rows into your database. If you didn't set a batch size in your DTS package, it may be doing everything in one large transaction, and this can be slow if it is forcing the transaction log file to grow.CODO ERGO SUM |
 |
|
|
ricky_newbee
Posting Yak Master
126 Posts |
Posted - 2006-01-20 : 16:08:57
|
| Mikeyou are correct. I did not set batch size in DTS package.what a Dumb ***.My log is 10 gigs any way :). but like you said it may take a while to complete. Thanks for you help any ways. |
|
|
|
|
|
|
DTS Transform Data Task