The execution tasks in the loop containers are being returned in alphabetical order of execution_path rather than based on loop number or exec time. So I'm getting them in FLC Task, FLC Task[4...
Id #24903 | Release:
| Updated: Nov 22 at 10:45 AM by SurbitonBoy | Created: Nov 22 at 10:45 AM by SurbitonBoy
With the command below I get two result sets, it would be great to only get one as shown in attached image.
Id #24860 | Release:
| Updated: Nov 8 at 1:42 PM by jamiet | Created: Nov 8 at 12:32 PM by SurbitonBoy
Suggested by Martin Cairns at https://twitter.com/MartinCairnsSQL/status/398759719663587328
Id #24858 | Release:
| Updated: Nov 8 at 10:36 AM by jamiet | Created: Nov 8 at 10:36 AM by jamiet
I'm not sure if this is really an issue with the reports, just a problem with Sharepoint-integrated SSRS or something else, but anyway:
Deployed the reports, some wo...
Id #24686 | Release:
| Updated: Sep 11 at 9:24 AM by BDee | Created: Sep 9 at 3:11 PM by BDee
When I call "Dts.Events.FireInformation" from with in an event handler the message is not displayed on the report "Execution".
Steps to replicate:
What I have is a "Sequence Container" with a...
Id #24620 | Release:
| Updated: Aug 14 at 5:27 PM by jamiet | Created: Aug 14 at 7:09 AM by iKill80
Report Pack Fails to Deploy folder-project-package. Bread crumb [@FolderId.Label] is invalid.
Also now the dashboard is here which report is the one the controls the accent color?
Id #24609 | Release:
SSIS Reporting Pack v18.104.22.168
| Updated: Sep 5 at 10:44 AM by jamiet | Created: Aug 12 at 12:53 PM by jonalberghini
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:
| Updated: Apr 9 at 2:36 PM by jamiet | Created: Apr 9 at 2: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:
| Updated: Feb 14 at 8:41 PM by jamiet | Created: Dec 19, 2012 at 12:48 PM 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:
| Updated: Feb 14 at 8:41 PM by jamiet | Created: May 16, 2012 at 11: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:
| Updated: Feb 14 at 8:41 PM by jamiet | Created: Apr 11, 2012 at 3:02 PM by jamiet