Post reply

SQl Server SSIS Job Monitor

  • December 17, 2011 at 2:25 am

    #249968

    I am running a SSIS job which contains 10 Data Flow Tasks as a SQL Agent job

    The job has been running for a while and I want to know at which step within the SSIS package the job has progressed to?

    Is there any way to monitor this?

    For e.g. Within BIDS environment, we can clearly see the Green colors as the package executes

    Any help will be appreciated

  • December 17, 2011 at 2:35 am

    #1422804

    It’s a good practice to add logging in SSIS package. SSIS package itself can log its activities to a file. Didn’t you implement anything like this in your SSIS package?

  • December 17, 2011 at 9:41 am

    #1422844

    This may help you for future executions: http://dtloggedexec.codeplex.com/[/url]

    DTLoggedExec provides an alternate to using DTExec for executing SSIS packages that can generate just about any logging information you like without adding any log configurations to the package itself.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

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

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