Integration Service Dashboard & Row Counts

  • I recently learned that SQL Server 2012/SSIS 2012 has a feature called the Integration Service Dashboard. Does this feature include row counts? If not, is there an efficient way to modify it to supposed row counts?

  • imani_technology (6/9/2014)


    I recently learned that SQL Server 2012/SSIS 2012 has a feature called the Integration Service Dashboard. Does this feature include row counts? If not, is there an efficient way to modify it to supposed row counts?

    It does not include row counts and no, you cannot modify it as it is an internal report inside Management Studio.

    The information is however stored inside the SSIS catalog so you can create your own reports.

    Logging Data Flow Workload in SSIS 2012

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

  • imani_technology (6/9/2014)


    I recently learned that SQL Server 2012/SSIS 2012 has a feature called the Integration Service Dashboard. Does this feature include row counts? If not, is there an efficient way to modify it to supposed row counts?

    I have not tried using these yet but someone did recreate the reports from SSMS and posted them to codeplex[/url]. So you could modify these to your liking.

    Shawn Melton
    Twitter: @wsmelton
    Blog: wsmelton.github.com
    Github: wsmelton

  • Shawn Melton (6/10/2014)

    I have not tried using these yet but someone did recreate the reports from SSMS and posted them to codeplex[/url]. So you could modify these to your liking.

    Are you referring to the SSIS Reporting Pack produced by Jamie Thompson? That's available at: http://ssisreportingpack.codeplex.com/

    Regards

    Lempster

  • imani_technology (6/9/2014)


    I recently learned that SQL Server 2012/SSIS 2012 has a feature called the Integration Service Dashboard. Does this feature include row counts? If not, is there an efficient way to modify it to supposed row counts?

    Using the basic level of logging in the catalog, I've found that custom logging using a script task returns OnInformation messages contining the custom log entries in the standard execution reports. Within the script task, use Dts.Events.FireInformation. There's an example in the help region. You could capture your row counts this way.

  • kl25 (6/10/2014)


    imani_technology (6/9/2014)


    I recently learned that SQL Server 2012/SSIS 2012 has a feature called the Integration Service Dashboard. Does this feature include row counts? If not, is there an efficient way to modify it to supposed row counts?

    Using the basic level of logging in the catalog, I've found that custom logging using a script task returns OnInformation messages contining the custom log entries in the standard execution reports. Within the script task, use Dts.Events.FireInformation. There's an example in the help region. You could capture your row counts this way.

    Or you could use the Rowcount transformation to store the result in a variable. And log that with an Execute SQL Task.

    Endless options, but nevertheless extra work unfortunately...

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

  • I like the rowcount transformation/Execute SQL Task option. What do you mean by logging with Execute SQL? How would I do it?

  • imani_technology (6/10/2014)


    I like the rowcount transformation/Execute SQL Task option. What do you mean by logging with Execute SQL? How would I do it?

    You simply execute an INSERT statement that inserts the value of the variable in a table.

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

Viewing 8 posts - 1 through 7 (of 7 total)

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