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.

All Forums  SQL Server 2000 Forums  Import/Export (DTS) and Replication (2000)  DTS to export to Sybase tables

Author  Topic  smb Starting Member 2 Posts Posted - 2004-03-11 : 22:04:09 Hi everybody. I'm having some problems with our DTS package. We designed a DTS packg to insert records to a Sybase table. The number of records to be transfered is 17 million. Right now, we are doing by batch of 100k records per run using a date criteria. We have transfered 6 million records already. The problem is that its taking too long. 40-60 mins for each run (avg 100k recs). When we run who2 or sp_who in our Sybase server during the run of the DTS package, it shows two processes. One inserting records to our table and the other a select stmt. Why is the package calling a select statement? We think this is the cause of the delay since its causing a table scan. We are using a DTS data pump to insert the records to the Sybase destination. We're really confused why there is a Select stmt process in Sybase (destination) during the DTS run. Is it some kind of data verification before the insert. If so, is there a way we can skip it entirely? Any help will be greatly appreciated. Thanks for the time.