Hello, What is the best way of documenting SSIS packages? I am not interested in purchasing any software, but I would appreciate it if anyone had a general template that covers the key information of any SSIS package that should be defined and documented. Thanks, Kajo Kajo

The best way to document a package is to add annotation to the package while designing the package. Annotation can be done at both control flow and data flow (Rt click and select add annotation). Nitesh Rai- Please mark the post as answered if it answers your question

It's a problem. One of these days I might create a little hack to prettyprint an SSIS package, but probably just the basic features that I use, connections, dataflows, SQL tasks, configurations - that's about it. The other two zillion features, I dunno. Make it open source and let everyone add to it, I guess. Josh

Lots of different ways of documentation out there. It all depends on what is necessary in your organization. Jamie T did a great blog post on reading the XML to gather some info: http://sqlblog.com/blogs/jamie_thomson/archive/2009/10/18/collecting-information-about-your-ssis-packages-ssis-nugget.aspx At a minimum I try to generate the dependencies for read / write / execute... in other words, if you need it to run the package, document it. There is a description property on nearly everything in SSIS. I suggest using them all. Also, annotations are great to give the first impression when opening up any design surface, although to be honest I have kind of gotten away from them in lieu of using the description properties mentioned above. Hope this helps!Please mark answered posts. Thanks for your time.