Posted: 9/30/2011
Can anybody point me to any info about programmatically generating an image of my packages?
--Cam
Posted: 10/2/2011
Please define what you mean by generate image of? Do you mean documentation of the package? If so, you can use our product BIDocumenter to do that for you http://pragmaticworks.com/Products/Business-Intelligence/BIDocumenter/Default.aspx
I am looking to essentially take a screenshot of the package... but do it programmatically from the package itself.
Yes BiDocumenter (found at http://pragmaticworks.com/Products/Business-Intelligence/BIDocumenter/Overview.aspx) does has this functionality. I have also tried out the free version and it is a great product. My main goal isn't to document my SSI packages. I have been using SSIS since 2005 and am very familiar with it.... and love it. However my c# skills are lacking. Because I know SSIS so well, I am using SSIS to help me in learning to code better. I have already learned how to extract all other data from the packages and the appropriate coding practices. Now I want to try to start drawing my packages.
It seems that I will have to get the data I need directly from the dtsx file... instead of loading the package into the SqlServer application. Is this accurate? Does any documentation exist on this?
Thanks,Cam
Cam,
A site primarily dedicated to Business Intelligence may not be your best source for learning how to program in C#. You may have better results, so you may want to post a similar question at http://www.tek-tips.com/. However, I just researched a little bit and found this link:
http://www.sitepoint.com/generating-asp-net-images-fly/
It shows how to create an image on the fly. With SSIS being xml code, it may be a bit more tricky, but I'm sure you'll figure something out.
Good luck,
Brian K. McDonald, SQLBIGEEK
Posted: 10/3/2011
Brian,
I have never been to http://www.tek-tips.com/ before. I will take a look at what it has to offer.
I am not worried about the code side. I am just looking for any information on where this information is at. Including any documentation that exists about this.
I ask on this site because I know that people that frequent this site know the answer... as they have done it.
I dont want to diminish your help. I do appreciate it and will be taking a look at Tek Tips now.