Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2003
    Posts
    9

    Exclamation Unanswered: 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!

  2. #2
    Join Date
    Jul 2003
    Posts
    1

    Re: Dts Problem....help....optimization

    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!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •