SSIS Custom Data Flow Components
SQL Server Integration Services (SSIS) include several most important components required in data acquisition, transformation, and load operations. If the problem at hand demands a solution that cannot be solved using the built-in components alone, you can resort to the freely extensible Script Component, but when the circumstances also call for a more complex, and more robust solution, that will be deployed to more than one destination server, the more appropriate alternative is to design a Custom Component. In this session you will learn how this can be achieved, what advantages it provides, and how to perform even the most complex data transformations in a standardized and reliable environment.
Sorry, there are no downloads available for this session.
Matija Lah is an independent consultant in the general and legal information management domains. Data warehousing represents and essential data management element in practically any business domain and Matija has had the opportunity to solve a variety of data warehousing problems since he started working with data warehouses in 2001. He shares many of his experiences in his blog at http://milambda.blogspot.com
, and is one of the authors in the popular book series SQL Server MVP Deep Dives. He is a frequent speaker on conferences related to technologies built on top of Microsoft platforms, especially conferences dedicated to Microsoft SQL Server. Matija has been a Microsoft Most Valuable Professional for SQL Server since 2007, and is a mentor in SolidQ, a trusted global provider of advanced consulting, mentoring and education solutions for the Microsoft platforms.
The video is not available to view online.