BI Project Deployment
SQL Server 2014
| Expert
- 11 videos | 1h 11m 24s
- Earns a Badge
The SQL Server 2014 ETL process provides a convenient way to populate your data warehouse database. Discover how to deploy ETL projects and packages, and manage ETL solutions.
WHAT YOU WILL LEARN
-
describe the differences between the package deployment model and the project deployment model, and project deployment model features
use parameters in packages, including sharing them
use the Integration Service Deployment Wizard to deploy projects to the SSISDB catalog using the project deployment model
set up a server environment to specify runtime values for packages within a project
use package configuration files to modify the properties of package elements at run time
build the SSIS project to create a package deployment utility with the packages for deployment -
copy the deployment folder and run the Package Installation Wizard to install packages to the file system or instance
configure security on packages requiring different security requirements
manage the SSIS catalog, including the modifying the catalog properties
use catalog stored procedures and views to manage SSIS objects
backup and restore the SSIS catalog, including moving it
IN THIS COURSE
-
7m 24sAfter completing this video, you will be able to describe the differences between the package deployment model and the project deployment model, and list project deployment model features. FREE ACCESS
-
8m 37sIn this video, you will use parameters in packages, including sharing them. FREE ACCESS
-
3. Using the Integration Service Deployment Wizard5m 35sIn this video, you will use the Integration Service Deployment Wizard to deploy projects to the SSISDB catalog. The project deployment model will be used. FREE ACCESS
-
4. Setting Up a Server Environment for a Project6m 40sFind out how to set up a server environment to specify runtime values for packages within a project. FREE ACCESS
-
5. Creating Package Configuration Files8m 40sIn this video, you will learn how to use package configuration files to modify the properties of package elements at runtime. FREE ACCESS
-
6. Creating a Package Deployment Utility3m 39sIn this video, you will build the SSIS project to create a package deployment utility. This utility will include the packages for deployment. FREE ACCESS
-
7. Installing Packages to the File System or Instance8m 58sDuring this video, you will learn how to copy the deployment folder and run the Package Installation Wizard to install packages to the file system or to an instance. FREE ACCESS
-
8. Configuring Package and Project Deployment Security5m 33sLearn how to configure security on packages with different security requirements. FREE ACCESS
-
9. Managing the SSIS Catalog6m 21sDuring this video, you will learn how to manage the SSIS catalog, including modifying the catalog properties. FREE ACCESS
-
10. Using Catalog Stored Procedure and Views for Logging6m 16sLearn how to use catalog stored procedures and views to manage SSIS objects. FREE ACCESS
-
11. Backing Up and Restoring the SSIS Catalog3m 40sDuring this video, you will learn how to backup and restore the SSIS catalog, including moving it to a new location. FREE ACCESS
EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.
Digital badges are yours to keep, forever.
