SSIS 2014, Part 10 of 11: Managing Packages

SQL Server and Integration Services provide plenty of tools for package management that you’ll learn about in this course. These include Management Studio and SQL Server Agent, as well as command line and graphical utilities like DTUtil, DTExec, and DTExecUI. With these tools you can execute packages in various ways and move, copy, and encrypt packages. To give one idea of how flexible these tools can be, there are at least four ways to execute a package, besides SQL Server Data Tools. You’ll learn some of the most important techniques for managing packages and some of the tools you can use, including those various ways to execute packages. There is a lot of overlapping functionality, so it is important to learn enough about all the tools so that you can use the ones best suited to your preferences, environment, and work style.

Lesson 1:

• Managing Packages with DTUtil
• DTUtil Exit Codes
• DTUtil Samples
• DTUtil Samples (cont.)
• Managing with Management Studio
• Demo: Managing with Mgmt Studio
• Demo: Mgmt Studio Features.

Lesson 2:

• Using the SSIS Catalog
• Demo: Creating an SSIS Catalog
• Demo: Exploring the Catalog
• Demo: Catalog Properties.

Lesson 3:

• Project Deployment
• Deploying Projects
• Demo: Converting a Project
• Demo: Select Configurations
• Demo: Convert & Test
• Demo: Deploy to SSIS Catalog
• Demo: Execute & Report.

Lesson 4:

• Executing Packages
• DTExecUI: Execute Pkg Utility
• Demo: DTExecUI.

Lesson 5:

• Demo: Execute at Cmd Line
• Demo: Executing Package.

Lesson 6:

• Demo: Start SQL Server Agent
• Demo: Configure & Execute Job.