O'Reilly logo

Microsoft SQL Server 2012 Integration Services: An Expert Cookbook by Pedro Perfeito, Reza Rad

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 1. Getting Started with SQL Server Integration Services

by Reza Rad and Pedro Perfeito

In this chapter, we will cover the following topics:

  • Import and Export Wizard: First experience with SQL Server Integration Services (SSIS)
  • Getting started with SSDT
  • Creating the first SSIS package
  • Getting familiar with Data Flow Task
  • SSIS 2012 versus previous versions in Developer Experience

Introduction

As technology evolves, it is always necessary to integrate data between different systems. The integration component is increasingly gaining importance, especially the component responsible for data quality as well as the cleaning rules applied between source and destination databases. Different vendors have their own integration tools and components, and Microsoft ...

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