O'Reilly logo

Beginning Microsoft® SQL Server® 2012 Programming by Paul Atkinson, Robert Vieira

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

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

imageNOTE 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, ...

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