O'Reilly logo

SQL Server DTS by Steve Hughes,, Steve Miller,, Marcelino Santos,, Brian Sullivan, Jim Samuelson,

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required