June 9, 2014 at 5:03 pm
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?
June 10, 2014 at 1:09 am
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
June 10, 2014 at 6:25 am
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
June 10, 2014 at 8:59 am
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
June 10, 2014 at 9:21 am
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.
June 10, 2014 at 10:08 am
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
June 10, 2014 at 10:36 am
I like the rowcount transformation/Execute SQL Task option. What do you mean by logging with Execute SQL? How would I do it?
June 10, 2014 at 11:58 am
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