Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Display SSIS log details in Drill- Down SSRS report Expand / Collapse
Author
Message
Posted Friday, March 29, 2013 1:49 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, January 20, 2014 5:30 AM
Points: 24, Visits: 146
Hi All,

I have a log table which stores the data, from log table I am able to find the duration for each task/ container.
From that log table I want to generate the Drill Down report.

I have attached the excel which has sample Log data and report.

Any suggestions will be really helpful


  Post Attachments 
Sample Log for Drill Down report.xls (6 views, 22.00 KB)
Post #1436837
Posted Friday, March 29, 2013 3:37 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 4:01 AM
Points: 12,206, Visits: 9,164
What are you exactly struggling with?



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1436850
Posted Friday, March 29, 2013 7:27 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, January 20, 2014 5:30 AM
Points: 24, Visits: 146
I want an idea on how should i build my sql query so that I can have parent-child kind of hierarchy. And then I can show that in SSRS report in drill-down format
Post #1436914
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse