Post reply

return step result information?

  • July 6, 2004 at 10:41 am

    #60198

    Is there a way to return information about the execution status of the steps in a package's run? Specifically, I'd like to return the number of rows affect in an update or an insert from the last run of a package.

    I have the package setup as a job which I call with an EXEC statement. The job, of course, only has one step, so it's not real useful.

    If I setup an error log for the package, it reports on each step's success/failure within the package. Is there any way to write the rows out to the log? There's got to be a native function for something like this. If possible, could it be retrieved with a system sp (rather than having to read the file)?

    Also, I'm running v7.

    TIA

  • July 7, 2004 at 2:24 am

    #513581

    If it would be possible for you to add something to the actual Package, you could follow the script with an select @@ROWCOUNT  that gets inserted into a log table that you create.   This would give you the number of rows affected.

    You could use the datetime as a key field.

  • July 7, 2004 at 9:53 pm

    #513776

    Unfortunately in v7 you don't have the inbuilt DTS package logging.

    You'll have to put something together yourself using either ActiveScript or ExecuteSQL tasks.

    --------------------
    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