|
BOS24-300: Creating Custom Components for SSIS
Presenter:
John Welch
Breakout Session
-
Level 300 (Advanced)
SSIS data flows are great tools for moving data. But what if you need to go beyond the out-of-the-box components provided with SSIS? Custom components are a great way to encapsulate and reuse functionality for the data flow in SSIS. We will discuss what it takes to create and deploy custom components in SSIS, review the pros and cons of using custom components instead of scripts, and discuss some of the common challenges and issues with creating them.
|
John Welch
BI Architect, Varigence
John Welch is BI Architect with Varigence, a company providing software that allows developers to create and maintain end-to-end business intelligence solutions with unprecedented ease of use and speed. John has been working with business intelligence and data warehousing technologies for 9 years, with a focus on Microsoft products in heterogeneous environments. He is a Microsoft Most Valued Professional (MVP), an award given due to his commitment to sharing his knowledge with the IT community. John is an experienced speaker, having given presentations at Professional Association for SQL Server (PASS) conferences, the Microsoft Business Intelligence conference, Software Development West (SD West), Software Management Conference (ASM/SM), and others. He has also contributed to three recent books on SQL Server 2008, “Microsoft SQL Server 2008 Management and Administration”, "Smart Business Intelligence Solutions with Microsoft SQL Server 2008", and “SQL Server MVP Deep Dives”.
John writes a blog on business intelligence topics at http://agilebi.com/cs/blogs/bipartisan. He also writes one focused on SSIS topics at http://agilebi.com/CS/blogs/jwelch/. He is also active in open source projects that help ease the development process for Microsoft BI developers, including BIDS Helper (http://www.codeplex.com/bidshelper), an add-in for Business Intelligence Development Studio that adds commonly needed functionality to the environment. He is also the lead developer on ssisUnit (http://www.codeplex.com/ssisUnit), a unit testing framework for SSIS.
Email:
john.welch@live.com
Website:
http://www.varigence.com
Blog:
http://agilebi.com/cs/blogs/jwelch
Twitter:
http://twitter.com/john_welch
|