Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SSIS project documentation Expand / Collapse
Author
Message
Posted Thursday, August 26, 2010 12:37 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, November 2, 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
Posted Thursday, August 26, 2010 8:52 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC 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
Posted Friday, August 27, 2010 1:41 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, September 12, 2014 11:45 AM
Points: 336, Visits: 867
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
Posted Saturday, August 28, 2010 11:50 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 7:44 AM
Points: 13,562, Visits: 11,372
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
Posted Monday, August 30, 2010 8:13 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

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

I will let you know after i use this tool ..
Post #977337
Posted Monday, August 30, 2010 8:14 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, November 2, 2010 10:14 AM
Points: 19, Visits: 100
Thanks for the replies with sugestions friends
Post #977339
Posted Monday, August 30, 2010 8:28 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, November 2, 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
Posted Monday, May 2, 2011 11:53 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, May 3, 2011 11:25 AM
Points: 51, Visits: 175
Here is one more Tool to document ssis packages
Post #1101822
Posted Friday, August 24, 2012 11:11 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, November 19, 2014 9:27 AM
Points: 143, Visits: 641
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 »

Add to briefcase

Permissions Expand / Collapse