Post reply

SSIS package audit

  • December 2, 2008 at 9:05 am

    #194529

    Hi All,

    I would like to know for some one the best way to do auditing in ssis package, I have given a requirement to find the record count and the starttime and endtime of task or package. how can i do this?

    Is here any stored procedure for this?

    Thanks in advance

    [font="Comic Sans MS"]
    ---------------------------------------------------

    Thanks [/font]

  • December 2, 2008 at 11:02 am

    #906390

    I have to log the following in a package :

    PackgStartTime

    PackageEndTime

    Rows Inserted

    Rows Updated

    Any help?

    [font="Comic Sans MS"]
    ---------------------------------------------------

    Thanks [/font]

  • December 2, 2008 at 11:21 am

    #906415

    To start with, right-click in the middle of the control flow and select "Logging" to turn on package logging. This will log events such as starts and ends of any of the components within your package.

    As far as record counts, it using the rowcount component in your data flow will allow you to set a variable to the number of rows being transformed and then you can use a SQL command component to insert the number into a table.

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

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