Chapter 8. Putting It All Together—An Extended DTS Example

Putting It All Together—An Extended DTS Example

Chapter 1, “DTS in the ETL World”, introduced Sparks Electronics, an electronics manufacturer and distributor with offices in several states. Chapter 2, “DTS—An Overview,” examined basic package components, and you saw how easy it is to create a stand-alone package that could be run on demand. Chapters 3 through 7 took a more in-depth look at DTS package components.

In this chapter, you get a chance to put all this knowledge together and build an automated system to collect and distribute reporting data for Sparks Electronics. In addition to building the package, you will examine issues ...

Get SQL Server DTS now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.