SQL Server SSIS Presentation
Val Matison will be presenting a session on documenting SQL Server Integration Services ETL packages at the next Toronto Code Camp, March 1, 2008.
Documenting ETL is awkward at best. SSIS supports some task level text elements but that’s the extent of it. How do non-SQL Users view ETL? What can be done within the packages to facilitate documenting the ETL process? This discussion will look at leveraging XML both in SSIS and SQL Server to create documentation that is stored in SQL Server and can be accessed via reporting services.
More information on the session is available here:
http://www.torontocodecamp.net/Sessions/tabid/55/CodecampId/1/SessionId/10/Default.aspx
Documenting ETL is awkward at best. SSIS supports some task level text elements but that’s the extent of it. How do non-SQL Users view ETL? What can be done within the packages to facilitate documenting the ETL process? This discussion will look at leveraging XML both in SSIS and SQL Server to create documentation that is stored in SQL Server and can be accessed via reporting services.
More information on the session is available here:
http://www.torontocodecamp.net/Sessions/tabid/55/CodecampId/1/SessionId/10/Default.aspx
posted by Val Matison at 10:01 AM
0 Comments:
Post a Comment
<< Home