Chapter 20
Getting Integrated with Integration Services
WHAT YOU WILL LEARN IN THIS CHAPTER:
- Your first exposure to the concepts of Extract, Transform, and Load procedures
- Using a wizard to create your first SQL Server Integration Services package
- How to navigate in the SSIS development environment within SQL Server Data Tools
- How to execute and deploy SSIS packages
NOTE If you’re running a mixed environment with SQL Server 2005 or 2008 (or migrating from one of those versions), do not fear. SQL Server 2012 Integration Services still supports older SSIS packages. Use the Integration Services Project Conversion Wizard within SSDT to help upgrade older SSIS packages to SSIS 2012 format.
In the previous chapter, you got your first serious taste of the SQL Server Data Tools (also sometimes referred to as SSDT). In case you skipped that chapter, SSDT is the Visual Studio development environment with some special SQL Server–oriented project templates and tools. The very different ways you can use that environment for just SQL Server development gives something of a taste for just how flexible the Visual Studio development environment is — as you’ll see, Integration Services has a pretty different feel than Reporting Services does.
In this chapter, you’ll be looking at how to utilize SQL Server Integration Services (often simply called SSIS) to perform basic import and export of data, ...