BI Project Deployment

SQL Server 2014    |    Expert
  • 11 videos | 1h 11m 24s
  • Earns a Badge
Rating 4.5 of 22 users Rating 4.5 of 22 users (22)
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 24s
    After 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 37s
    In this video, you will use parameters in packages, including sharing them. FREE ACCESS
  • Locked
    3.  Using the Integration Service Deployment Wizard
    5m 35s
    In 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
  • Locked
    4.  Setting Up a Server Environment for a Project
    6m 40s
    Find out how to set up a server environment to specify runtime values for packages within a project. FREE ACCESS
  • Locked
    5.  Creating Package Configuration Files
    8m 40s
    In this video, you will learn how to use package configuration files to modify the properties of package elements at runtime. FREE ACCESS
  • Locked
    6.  Creating a Package Deployment Utility
    3m 39s
    In this video, you will build the SSIS project to create a package deployment utility. This utility will include the packages for deployment. FREE ACCESS
  • Locked
    7.  Installing Packages to the File System or Instance
    8m 58s
    During 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
  • Locked
    8.  Configuring Package and Project Deployment Security
    5m 33s
    Learn how to configure security on packages with different security requirements. FREE ACCESS
  • Locked
    9.  Managing the SSIS Catalog
    6m 21s
    During this video, you will learn how to manage the SSIS catalog, including modifying the catalog properties. FREE ACCESS
  • Locked
    10.  Using Catalog Stored Procedure and Views for Logging
    6m 16s
    Learn how to use catalog stored procedures and views to manage SSIS objects. FREE ACCESS
  • Locked
    11.  Backing Up and Restoring the SSIS Catalog
    3m 40s
    During 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.

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Rating 4.5 of 71 users Rating 4.5 of 71 users (71)
Rating 4.4 of 16 users Rating 4.4 of 16 users (16)
Rating 4.5 of 57 users Rating 4.5 of 57 users (57)