Results 1 to 2 of 2

Thread: DTS Active Script Task

  1. 10-08-1999, 09:47 AM #1
    Balaji Guest

    DTS Active Script Task

    Hi

    Can anyone tell if a COMMIT can be given inside a Active script task in a DTS package? This task performs a transfers a few thousand records from Oracle to SQL row-by-row and I want to commit after each row is processed and not at the completion of the full task. Is this possible.

    Balaji

    Reply With Quote Reply With Quote
  2. 10-08-1999, 02:20 PM #2
    Peter Cwik Guest

    DTS Active Script Task (reply)


    You bet it is. From the designer, double click on your transformation, then on the advanced tab, look at data movement. Set your commit level to your liking...

    ------------
    Balaji at 10/8/99 10:47:28 AM

    Hi

    Can anyone tell if a COMMIT can be given inside a Active script task in a DTS package? This task performs a transfers a few thousand records from Oracle to SQL row-by-row and I want to commit after each row is processed and not at the completion of the full task. Is this possible.

    Balaji

    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules