Chapter 2. SQL Server Import and Export Wizard

In This Chapter

Starting SSIS Import and Export Wizard

Using Business Intelligence Development Studio

Summary

Businesses of today are dealing with customers via a variety of channels—post mail, telephone, e-mail, text message, web portal, agent, dealer, direct marketing, through business partners, and the list goes on. This increased access to data means that data must be stored in a variety of places using new methodologies, and in a variety of different data storage systems. Along with storage requirement considerations, the sheer volume of data can be overwhelming.

Data must be integrated from all disparate sources rapidly within the organization to help it better understand its customers. It ...

Get Hands-On Microsoft SQL Server™ 2005 Integration Services 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.