Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 13. Introduction to SQL Server 2005 Integration Services

Chapter 13. Introduction to SQL Server 2005 Integration Services

With the release of SQL Server 2005, Microsoft introduced a replacement to its Data Transformation Services (DTS) known as SQL Server Integration Services (SSIS). Familiarity with DTS, fortunately, is not prerequisite knowledge for understanding the concepts in this chapter. This chapter is designed to help you understand the features and management of SSIS. Although this chapter will not (and realistically cannot) be an exhaustive review of SSIS, it should give you a good foundation of understanding how data can be moved between various sources and destinations, and how it can be modified in the process. This chapter covers the following topics:

  • A general introduction to SSIS and its features

  • The import and export tools used to move data around

  • The different options for transforming data using SSIS


  

You are currently reading a PREVIEW of this book.

                                                                                                                    

Get instant access to over $1 million worth of books and videos.

  

Start a Free Trial


  
  • Safari Books Online
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint