Post reply

Log Space Usage of DTS

  • March 11, 2003 at 3:24 am

    #106368

    Hello everyone,

    I have a simple DTS package that uses a Transform Data Task to copy approx 8000 rows from one table/server to another. The problem is that it uses 3.5 meg of log space on each execution and it is executed every 15 mins. The Transform Task uses the Fast 'Load option' and the database is set to 'Simple' recovery mode. Short of truncating the log after each execution, is there a way to minimise the log usage?

    Thanks.

  • March 11, 2003 at 4:09 am

    #450767

    In this situation the answer is No. You could try exporting to a flat file and use bcp to bulk copy the data in, it produces less transactions but may take longer and can run into issues if you need guaranteed delivery.

  • March 11, 2003 at 2:34 pm

    #450834

    Check the indexing on the table you're inserting into. Check 'Optimizing Bulk Copy Performance' in books online.

    If you export the data to a flat file, use Bulk Insert to import the data.

    Hope this helps

    Phill Carter

    --------------------

    Colt 45 - the original point and click interface

    --------------------
    Colt 45 - the original point and click interface

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply