O'Reilly logo

Guru's Guide to SQL Server Architecture and Internals, The by Ken Henderson

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

Other Types of Transformations

I said at the beginning of the chapter that I wouldn't bore you with every single DTS feature and usage detail. You can glean most of these yourself by reading through Books Online and by building a few packages. That said, a few of the more esoteric features bear mentioning. One is the WriteFile transformation. A WriteFile transformation allows you to take two source columns—one supplying a file name and the other supplying the file's data—and transform them into an external text file for each row in the source table. The text file can be written in ANSI, UNICODE, or OEM format. The WriteFileExample.DTS package in the CH20 folder on the CD accompanying this book demonstrates how to use a WriteFile task to transform ...

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