Results 1 to 3 of 3

Thread: running a stored procedure using the Execute sql task

  1. 03-13-2001, 05:44 AM #1
    and Guest

    running a stored procedure using the Execute sql task

    Hi

    Is it possible in my DTS Package to check if a stored procedure which I'm executing from the Execute sql task icon can be tested for failure?
    Reply With Quote Reply With Quote
  2. 03-13-2001, 08:28 AM #2
    Paul Guest

    running a stored procedure using the Execute sql task (reply)


    Within your SP make sure that there is error handling code !!!

    ------------
    and at 3/13/01 5:44:58 AM

    Hi

    Is it possible in my DTS Package to check if a stored procedure which I'm executing from the Execute sql task icon can be tested for failure?
    Reply With Quote Reply With Quote
  3. 03-13-2001, 08:59 AM #3
    and Guest

    running a stored procedure using the Execute sql task (reply)

    and how do I pass that back to the DTS?


    ------------
    Paul at 3/13/01 8:28:26 AM


    Within your SP make sure that there is error handling code !!!

    ------------
    and at 3/13/01 5:44:58 AM

    Hi

    Is it possible in my DTS Package to check if a stored procedure which I'm executing from the Execute sql task icon can be tested for failure?
    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