Chapter 9. Extracting, Transforming, and Loading Data

IN THIS CHAPTER, YOU WILL LEARN TO DO THE FOLLOWING:

  • USE THE BULK COPY PROGRAM UTILITY (Pages 304 – 309)

    • Perform a Standard BCP Task (Page 306)

    • Use BCP Format Files (Page 307)

    • Use Views to Organize Output (Page 309)

  • USE THE SQL SERVER IMPORT AND EXPORT WIZARD (Pages 309 – 316)

    • Execute the Import and Export Wizard (Page 310)

    • Saving and Scheduling an Import/Export (Page 314)

  • CREATE TRANSFORMATIONS USING SQL SERVER INTEGRATION SERVICES (SSIS) (Pages 316 – 332)

    • Create a Data Connection (Page 320)

    • Implement a Data Flow Task (Page 322)

    • Perform a Transformation (Page 327)

    • Implement Control of Flow Logic (Page 332)

Extracting, transforming, and loading (ETL) are fundamental processes to any data environment. ...

Get SQL Server® 2008 Administration: Instant Reference 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.

Start your free trial