Chapter 24. Building Custom Tasks


In This Chapter

  • Custom Runtime Components

  • Starting an SSIS Custom Component Project

  • Developing and Debugging the Task

  • Building the Task User Interface

  • Custom Task Best Practices

"SOMEBODY MUST HAVE BEEN REALLY HUNGRY IN THIS HALL."

MATT DAVID

If you were to decompose Integration Services and remove all the components, you'd be left with very little value because packages wouldn't do anything. They would just sit there, wishing you'd build a task or other component to plug into them so they would have something to do. The tasks, transforms, Foreach Enumerators, connection managers, data flow adapters, and log providers are what provide the power of SSIS. Without them, you'd be left with two snoozing engines and a designer. What's interesting is that, as a third-party developer, you can write components that are exactly like the stock components that ship with Integration Services. The SSIS team used the same infrastructure to write components as you can use to build custom components. This chapter generically describes how to start a project for building all the custom components and then covers in detail how to write custom tasks just like the stock tasks that ship with the product. The next chapter, Chapter 25, "Building Custom Data Flow Components," covers how to build adapters and transforms.



Microsoft SQL Server 2005 Integration Services
Microsoft SQL Server 2005 Integration Services
ISBN: 0672327813
EAN: 2147483647
Year: 2006
Pages: 200
Authors: Kirk Haselden

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net