October 29, 2011 at 12:40 am
hi,
i am new to ssis , i have to document few packages.
how to prepare documents for ssis packages?
is there any free tools?
send me some sample documents if available.
thank you.
October 29, 2011 at 3:19 pm
It depends on what level of documentation you require.
There are some tools out there that will create ssis documentation for you, a google search will bring them up, but most of them require a payment.
I have documented SSIS packages before by parsing the xml of the package to retrieve the neccesary information required for my document.
Also try and make you packages as 'self-documenting' as possible with descriptive names and comments.
October 31, 2011 at 6:18 am
I would recommend also adding annotations to your packages. A well placed note can help explain/document what your package is doing and the logic being used.
November 1, 2011 at 1:43 pm
Check that out...
http://www.ssisdocumenter.com/
also there's another tool from pragmatic-works, but it's more fancy, it uses a sql table to log the stuff in.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply