The idea is simple, I'd like to be able to export a picture of what my SSIS packages look like. If they're small enough, I can just take a screenshot. If they're sizable though, I have to take lots of shots, stitch them together and it really shouldn't be that hard. I can build packages programatically. I have a basic comprehension of the object model but I'll be dogged if I can figure out how to determine any of the presentation "crap." UI stuff has never been my strong suit but this is worse than usual. What I know: it's all XML. The root element is a Package and then it specifies all this stuff about what the objects are and where they are on the canvas. Maybe I'm blind, but I'm not seeing anything in Microsoft.SqlServer.Dts.Runtime that indicates any object has a clue about coordinates. Not the Package, not the Executable, none of that. I'll keep digging but it might be faster for me to get to SQL PASS and try to talk to a MS developer about it. Maybe it'd be easier to try and write a Visual Studio plugin that does nothing more than expose and Export method. BIDS Helper might be a good starting point for that.
At any rate, blog rate has slowed but there are still plenty of ideas rolling about in the noggin and this is one of them.
Bingo! BIDSHelper, ExpressionHighlighterPlugin.cs looks like it's got code in there to deal with the canvas. Microsoft.DataWarehouse.Design.EditorWindow has stuff for display-centric stuff.[/edit]
A blog about SQL Server, SSIS, C# and whatever else I happen to be dealing with in my professional life.
- ► 2012 (14)
- ► 2011 (35)
- ► 2010 (53)
- ▼ October (8)
- ► 2008 (15)
#TSQL2sDay (3) .NET (1) ADO.NET provider (1) asp.net (1) benchmark (1) Bingo (2) Bot detector (1) build events (1) C# (10) CTE (6) cv (1) datawarehouse modeling (1) deadlock (1) Denali (3) dtutil (2) Engine of the Devil (3) Excel (1) EXECUTE AS (1) Execute SQL Task (1) EzAPI (7) F# (3) facebook (1) html (1) identity theft (1) itms (1) linked servers (1) Macbook Pro (1) Macros (2) meme monday (4) Merge Join (1) MS SQL Server (34) MySQL (2) n00b (1) Parameters (1) parsing (2) permissions (2) powershell (5) presentation (1) Profiler (1) Project Euler (2) python (1) Ranking (1) Resume (1) RSClientPrint (2) schema (1) shameless self promotion (1) SQL Lock In (1) SQL PASS (1) SQL Saturday (3) SQL Saturday 53 (8) SQL Saturday 91 (1) SQL Server 2005 (22) SQL Server 2008 (13) SSAS (1) SSIS (31) SSISUploader (1) SSISUploader SSIS (3) SSMS (1) SSRS (2) standards (1) stupid (1) Summit 2009 (2) Tofslie (1) troubleshooting (1) TSQL (26) Twitter (2) UAC (1) Visual Studio (3) Visual Studio 2010 (1) Windows Server 2008 R2 (1) XML (1) yahoo (1)