SSIS 2014, Part 09 of 11: Configuring and Deploying Packages
Interactive

SSIS 2014, Part 09 of 11: Configuring and Deploying Packages

Biz Library
Updated Feb 04, 2020

More often the package or project you are working on will need to be robust enough to run repeatedly. In that case, you’ll need to deploy the package to a server and sometimes multiple servers, and Integration Services has a number of features that make this process easier, which you’ll learn about in this course. The typical lifecycle of an Integration Services package has several phases. Each phase of the lifecycle may require that you use a different set of resources for the package. Items such as file paths and connection strings will vary from phase to phase. A feature called configurations allow you to create packages that are not bound to any particular location or environment, and you’ll see how to use configurations in this course. Once your package is ready to be flexible enough to execute on various servers, you’ll need to deploy it to one or more servers. You’ll need to progress through several steps to develop packages and deploy them from one environment to another, and you’ll learn how to do that in this course.


Lesson 1:

  • Using Configurations
  • Sample Path
  • Configuration Storage
  • Demo: Configurations
  • Demo: Enumerator Config.

Lesson 2:

  • Parent and Child Scenarios
  • Direct & Indirect Configuration
  • Demo: Indirect Configuration.

Lesson 3:

  • Deploying Packages
  • Deployment Challenges
  • Deployment-Sensitive Components
  • Utilities That Can Help
  • Package Deployment Utility
  • Deployment Utility Properties
  • Deployment Folder
  • Deployment Manifest.

Lesson 4:

  • Demo: A Pkg Deployment Utility
  • Demo: Create the Utility.

Lesson 5:

  • The Package Installation Wizard
  • Deploy a Pkg to the File System
  • Demo: Package Installation
  • Demo: The Log File
  • Demo: Management Studio.

Lesson 6:

  • Deploying to SQL Server
  • Demo: Deploying to SQL Server.

Lesson 7:

  • Demo: Using Management Studio
  • Deploy SQL Server vs File System
  • Redeploying Updated Packages.