Exporting using DTS to SQL6.5

[Ajay]

I created a DTS task to transfer data from a SQL7.0 table to a SQL6.5 table. This trasfer is really slow.

The transfer the other way is amazingly fast.

Any ideas ??

Thank you in advance.

[Carly]

What indexes do you have ?
Are there any triggers ?



------------
Ajay at 10/29/99 5:36:13 PM

I created a DTS task to transfer data from a SQL7.0 table to a SQL6.5 table. This trasfer is really slow.

The transfer the other way is amazingly fast.

Any ideas ??

Thank you in advance.

[Ajay]

There are indexes on the table on both sides.
There are triggers on SQL7.0 server, but none on the SQL 6.5 side.
Any help would be greatly appreciated.

Thank you.

------------
Carly at 11/1/99 3:34:47 AM

What indexes do you have ?
Are there any triggers ?



------------
Ajay at 10/29/99 5:36:13 PM

I created a DTS task to transfer data from a SQL7.0 table to a SQL6.5 table. This trasfer is really slow.

The transfer the other way is amazingly fast.

Any ideas ??

Thank you in advance.