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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-11-19 : 08:34:19
|
| Sydney writes "Hello,Basically, I have a DTS Package running on Windows 2000 Server, that uses DB2 Connect (ODBC from IBM) to establish connection to IBM DB2 database. DTS Package selects records from SQL2000; uses Data Pump Task and Copy Column to copy records to a DB2 table. The process is slow because, for some reason, it is performing a "READ" on the entire DB2 table before it actually inserts the records on the destination. What is causing this to happen?I have been researching/reading lots of articles in the newsgroups for ibm and dts. I'd greatly appreciate anyonewho can any help to this problem.Thanks in advance.Sydney Luusdluu@sunocoinc.com" |
|
|
|
|
|
Why does DTS read before inserting records???