Have you tried to implement query parallelism?..it's a good method to improve the performance!..
SAS International Headquarters
Tom Berranger, Manager
SAS Institute GmbH
P.O. Box 105340
Neuenheimer Landstr. 28-30
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.
Originally posted by LULU
I would like to request your precious help!!
I´m having a little problem of performance in the package DTS of SQL SERVER 2000!
I´ve made the mapping between the data with DDQ and i´ve made the inserts and the updates with Stored Procedures.. but the performance is very weak and is too slow!!!