Dts Problem....help....optimization

Hello everyone..

I would like to request your precious help!!

Im having a little problem of performance in the package DTS of SQL SERVER 2000!

Ive made the mapping between the data with DDQ and ive made the inserts and the updates with Stored Procedures.. but the performance is very weak and is too slow!!!

How can i optimize this?

Thank you all!Hello LULU,
Have you tried to implement query parallelism?..it's a good method to improve the performance!..

Tom B.

SAS International Headquarters
Tom Berranger, Manager
SAS Institute GmbH
P.O. Box 105340
Neuenheimer Landstr. 28-30
D-69043 Heidelberg
GERMANY

ps: I see that you work with SQL Server?...i work for a multinational that works with this tool and we are looking for junior consultant in this area.
So if you are interested..please let me know...you have just to send a mail for this forum.
thanks.

Originally posted by LULU
Hello everyone..

I would like to request your precious help!!

Im having a little problem of performance in the package DTS of SQL SERVER 2000!

Ive made the mapping between the data with DDQ and ive made the inserts and the updates with Stored Procedures.. but the performance is very weak and is too slow!!!

How can i optimize this?

Thank you all!