Post reply

Email package results

  • November 2, 2005 at 4:01 pm

    #68505

    Hi there,

    I would like to email the dts package execution results upon completion of the package. This would include rows transformed from each step along with the step success/failure.

    What has been people's experience with this?

    Is it better to do via ActiveX within the package as the last step, or through SQL Server Agent?

    Also, how can I change the step name to reflect the description so it is something more meaningful than "DTSStep_DTSExecuteSQLTask_1".

    Regards,

    David

  • November 3, 2005 at 2:19 am

    #602058

    Hi,

    Also, how can I change the step name to reflect the description so it is something more meaningful than "DTSStep_DTSExecuteSQLTask_1".

    In DTS Designer, select Package - Disconnected Edit, then expand the node Steps. Select the desired node (DTSStep_DTSExecuteSQLTask_1) and edit the Name property (edit the Description Property as well while you're in here).

    Regards

    /Lars

     

  • November 3, 2005 at 3:39 pm

    #602264

    Thanks Lars - you're a champ!

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

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