Post reply

SSIS Logging

  • March 12, 2012 at 1:27 pm

    #391783

    Hi All,

    I have to capture the package name,source,destination,source count and destination count

    into one table(Audit Table) for each sucessful running package.

    Thanks,

    Mark

  • March 12, 2012 at 3:51 pm

    #1458227

    Hi

    By using system variables and user variables in executesqltask u can get that requirement:-)

  • March 13, 2012 at 12:29 am

    #1458307

    This is a good blog post to start with:

    SSIS: Custom Logging Using Event Handlers

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • March 13, 2012 at 7:34 am

    #1458462

    Thanks for Giving Answer But here my requirement

    Actually there are around 150 ssis jobs are running on one of server.

    At the initially they did not design the logging

    Now my task should be I have to implement one step in the every job

    That step may be t-sql or ssis

    In the next step(After the SSIS Package) I have to retrive source,destination,jobname ,row count for source and destination

    I have to apply above step for 150 SSIS Jobs.

    Mainly I have to implement the logging wiht out touching the SSIS Packages

    Thanks,

    Mark

  • March 13, 2012 at 7:35 am

    #1458464

    Thanks for Giving Answer But here my requirement

    Actually there are around 150 ssis jobs are running on one of server.

    At the initially they did not design the logging

    Now my task should be I have to implement one more step in the every job

    That step may be t-sql or ssis

    In the next step(After the SSIS Package) I have to retrive source,destination,jobname ,row count for source and destination

    I have to apply above step for 150 SSIS Jobs.

    Mainly I have to implement the logging wiht out touching the SSIS Packages

    Thanks,

    Mark

  • March 13, 2012 at 8:04 am

    #1458493

    I don't think you can achieve your requirements without touching the SSIS packages.

    There's no way of finding out how many rows were affected without logging it somewhere.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

Viewing 6 posts - 1 through 5 (of 5 total)

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