SSIS 2014, Part 09: Configuring and Deploying Packages

with expert Don Kiely

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.

Course Outline