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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.