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 9. Deployment

by Reza Rad

In this chapter, we will cover the following topics:

  • Project Deployment Model: Project Deployment from SSDT
  • Using Integration Services Deployment Wizard and command-line utility for deployment
  • Package Deployment Model: Using SSDT to deploy packages
  • Creating and running Deployment Utility
  • DTUTIL—the command-line utility for deployment
  • Protection level: Securing sensitive data

Introduction

Till now you have read many chapters on the development of packages; this chapter focuses on another phase of ETL or data transfer implementation, which is deployment. Every package and project that we created in the previous chapters works correctly on SSDT. However, note that a production environment probably doesn't have SSDT installed, ...

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