March 20, 2026 at 12:15 am
Hi everyone
I am looking at building a query to determine how much time is being spent on each task in SSIS. My SSIS package has a few containers and within each container there are tasks. Once one container finishes processing then the next container gets processed. I have never done this before so I am not sure how to begin. I have been playing around with dbo.sysssislog. I am noticing that some tasks that are completed in SSIS are not appearing when I query it. Here is my query:
select *
from dbo.sysssislog
where convert(date,starttime) = '2026-03-19' and [source] like '%download%'
order by id
The purpose of this query is to make sure that I am capturing all the tasks that have "download" in it. But this is not happening. In my SSIS there are 3 separate tasks that contain the keyword "download" but only one gets returned. I am doing something wrong but I am not sure what. Once I see all the tasks with "download" then I can remove the filter. The end goal is to capture all tasks not just ones that have "download" in them. Can someone please help guide me and let me know what I am doing wrong?
Thank you
March 20, 2026 at 7:33 am
Assuming your SSIS packages are deployed to SSISDB, try looking inside
SSISDB.catalog.operations
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply