SSIS project documentation

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 Integration Services » SSIS project documentation

SSIS project documentation

Rate Topic

Display Mode

Topic Options

Author

Message

sql_freak

Posted Thursday, August 26, 2010 12:37 PM

Grasshopper

Group: General Forum Members
Last Login: Tuesday, November 02, 2010 10:14 AM
Points: 19, Visits: 100

Hello,

My ssis project is almost done. Now we heading 2wards documentation .

Could any one give me suggestions,guidelines.tools,samples or ideas

Post #975868

chrisrock

Posted Thursday, August 26, 2010 8:52 PM

SSC Journeyman

Group: General Forum Members
Last Login: Wednesday, January 12, 2011 7:03 AM
Points: 79, Visits: 32

My company has a product called BI Documenter that will document your SSIS projects.

Check it out and let me know what you think

_______________
Convert DTS to SSIS | Database Documentation | SSIS Performance | SSIS Monitoring

Post #976104

Learner1

Posted Friday, August 27, 2010 1:41 PM

Old Hand

Group: General Forum Members
Last Login: Wednesday, April 25, 2012 12:30 PM
Points: 323, Visits: 800

You can create an excel file with separate sheets for easch package and paste a screenshot of your package then below that expalin what every task does.

---------------------------------------------------

Thanks

Post #976719

Koen Verbeeck

Posted Saturday, August 28, 2010 11:50 AM

SSCrazy Eights

Group: General Forum Members
Last Login: Yesterday @ 6:54 AM
Points: 9,364, Visits: 6,462

Some of the most important things of the ETL that you must document:

* data mapping (given a certain output column, which are the contributing input columns)
* information liquidity model: describes the "flow" of the data through the whole ETL process

Powerdesigner (a data modelling tool) has the capabilities to document this in great detail (even create the deployment scripts for the databases), but it is a rather complex tool.

And of course, your code should document itself. Add annotations in your package, add in line comments in your T-SQL and .NET code.

How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence

Post #976980

sql_freak

Posted Monday, August 30, 2010 8:13 AM

Grasshopper

Group: General Forum Members
Last Login: Tuesday, November 02, 2010 10:14 AM
Points: 19, Visits: 100

Thanks chrisrock

I will let you know after i use this tool ..

Post #977337

sql_freak

Posted Monday, August 30, 2010 8:14 AM

Grasshopper

Group: General Forum Members
Last Login: Tuesday, November 02, 2010 10:14 AM
Points: 19, Visits: 100

Thanks for the replies with sugestions friends

Post #977339

sql_freak

Posted Monday, August 30, 2010 8:28 AM

Grasshopper

Group: General Forum Members
Last Login: Tuesday, November 02, 2010 10:14 AM
Points: 19, Visits: 100

@chisrock:

I tried using the tool after downloading a free trail but it doesn't lemme do any thing unless i buy that...

Post #977350

SSIS Guy

Posted Monday, May 02, 2011 11:53 AM

Valued Member

Group: General Forum Members
Last Login: Tuesday, May 03, 2011 11:25 AM
Points: 51, Visits: 175

Here is one more Tool to document ssis packages

Post #1101822

Jeffery Williams

Posted Friday, August 24, 2012 11:11 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 6:14 AM
Points: 137, Visits: 592

Personally I love ApexSQL products. They have one called ApexSQL Doc.

This will document the entire database including any objects, ssis, ect.

You can select the databases, tables, functions, SPROC's, SSIS, ect that you want or don't. It includes text documentation, UML, relationship diagrams; and so-on.

Very Very good stuff.

http://www.apexsql.com

<hr noshade size='1' width='250' color='#BBC8E5'>

Regards,

Jeffery Williams
http://www.linkedin.com/in/jwilliamsoh

Post #1349824

« Prev Topic | Next Topic »

Permissions