I built 8 ssis reporting pack connected on different 8 servers.
On 2 servers, the report "most recent failed execution" never end.
I applied the corrections of indexing [internal].[event_message_co...
Id #24155 | Release:
None
| Updated: Apr 9 at 1:36 PM by jamiet | Created: Apr 9 at 1:10 PM by yann_nguyen
Often you don't want to know how long containers, only the actual tasks themselves. Build something into sp_ssiscatalog that enables one to see this.
Id #23721 | Release:
None
| Updated: Feb 14 at 7:41 PM by jamiet | Created: Dec 19, 2012 at 11:48 AM by jamiet
In an example a "select * from exec_stats_recursed" (where exec_stats_recursed is a CTE in the query that drives this report) took 8mins to return ~4000rows and was still going. It also brought my ...
Id #22777 | Release:
None
| Updated: Feb 14 at 7:41 PM by jamiet | Created: May 16, 2012 at 10:11 AM by jamiet
In "execution executale duration.dtsx" we have the following query:
WITH [exec_stats] AS (
SELECT em.[execution_path],SUBSTRING(em.[execution_path],1,LEN(em.[execution_path]) - CHARINDEX('\',REVERS...
Id #22491 | Release:
None
| Updated: Feb 14 at 7:41 PM by jamiet | Created: Apr 11, 2012 at 2:02 PM by jamiet
When I preview the reports in BIDS 2010, the links from dashboard.rdl to other reports works fine. When I deploy the project to a Denali CTP3/SP 2010 SP1 integrated report server instance, any tex...
Id #21451 | Release:
None
| Updated: Feb 14 at 7:41 PM by jamiet | Created: Sep 6, 2011 at 6:59 PM by DrewskyJones
"Dataflow" and "Dataflow outputs" should contain package & dataflow name in breadcrumbs. Currently only goes down to folder name.
Id #21359 | Release:
None
| Updated: Feb 14 at 7:41 PM by jamiet | Created: Aug 17, 2011 at 9:30 PM by jamiet
An attempt was made to set a report parameter 'Status' that is not defined in this report. (rsUnknownReportParameter)
Specifically, I clicked on the link in the "succeeded" column
Id #21358 | Release:
None
| Updated: Feb 14 at 7:41 PM by jamiet | Created: Aug 17, 2011 at 9:20 PM by jamiet
"Last 5 executions" on dashboard- tooltip should show logging level. Thus easy to show difference verbose logging can make.
Id #21357 | Release:
None
| Updated: Feb 14 at 7:41 PM by jamiet | Created: Aug 17, 2011 at 8:52 PM by jamiet
"Last 5 executions" on dashboard should show currently executing executions. It doesn't currently.
Id #21356 | Release:
None
| Updated: Feb 14 at 7:41 PM by jamiet | Created: Aug 17, 2011 at 8:52 PM by jamiet
This maybe should reflect active time & wall clock time.
Id #21238 | Release:
None
| Updated: Feb 14 at 7:41 PM by jamiet | Created: Jul 27, 2011 at 8:34 AM by jamiet