Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Visualization Tool(s)

Author  Topic 

Lamprey
Master Smack Fu Yak Hacker

4614 Posts

Posted - 2010-04-13 : 14:41:47
I wasn't sure where to put this so I put in the New section..

But, I was wondering if anyone knows of any "visual tool" that will allow you to drill-down into levels of detail? Not the best description, so let me explain a bit...

For example, I have some SQL Agent Jobs that have Steps. Each step calls an SSIS package. Each package does some unit of work, say move table 1 from server A in database Z to table 2 in database Y on server B.

At a high level (think Visio) I want to show a block with the name of a SQL Agent Job. Then you click that and you get the next level, Steps. Then clicking on the step leads to the SSIS package, and so on.

The nice thing would be able to view the entire thing at once too in order to get a sense of the complexity.

At any rate, just thought I'd check to see if anyone has any suggestions

Cheers!
   

- Advertisement -