Sunday, January 27, 2008

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

0 Comments:

Post a Comment

<< Home