Post reply

DTS Package output

  • March 25, 2003 at 1:19 am

    #158981

    Hi

    How do i get the result of the DTS Package? say how many records transfered and how many failed and reasons kind of stuff.

  • March 28, 2003 at 8:00 am

    This was removed by the editor as SPAM

  • April 1, 2003 at 7:41 pm

    #452787

    Thyravi,

    In SQL 2000, open the Transform Data Task Properties dialog and select the error reporting you want.

    If you use scripting or program in VB you can set transaction flags on the objects and use error logs to process failed transactions or notify DBA via email.

    Hope that helps,

    Rob

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

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