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 featuresuse parameters in packages, including sharing themuse the Integration Service Deployment Wizard to deploy projects to the SSISDB catalog using the project deployment modelset up a server environment to specify runtime values for packages within a projectuse package configuration files to modify the properties of package elements at run timebuild 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 instanceconfigure security on packages requiring different security requirementsmanage the SSIS catalog, including the modifying the catalog propertiesuse catalog stored procedures and views to manage SSIS objectsbackup and restore the SSIS catalog, including moving it
IN THIS COURSE
-
1.The Project Deployment Model7m 24sUP NEXT
-
2.Using Parameters in Packages8m 37s
-
3.Using the Integration Service Deployment Wizard5m 35s
-
4.Setting Up a Server Environment for a Project6m 40s
-
5.Creating Package Configuration Files8m 40s
-
6.Creating a Package Deployment Utility3m 39s
-
7.Installing Packages to the File System or Instance8m 58s
-
8.Configuring Package and Project Deployment Security5m 33s
-
9.Managing the SSIS Catalog6m 21s
-
10.Using Catalog Stored Procedure and Views for Logging6m 16s
-
11.Backing Up and Restoring the SSIS Catalog3m 40s
EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform
Digital badges are yours to keep, forever.