BI Project Deployment

SQL Server 2014
  • 11 Videos | 1h 14m 24s
  • Earns a Badge
Likes 12 Likes 12
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

  • Playable
    1. 
    The Project Deployment Model
    7m 24s
    UP NEXT
  • Playable
    2. 
    Using Parameters in Packages
    8m 37s
  • Locked
    3. 
    Using the Integration Service Deployment Wizard
    5m 35s
  • Locked
    4. 
    Setting Up a Server Environment for a Project
    6m 40s
  • Locked
    5. 
    Creating Package Configuration Files
    8m 40s
  • Locked
    6. 
    Creating a Package Deployment Utility
    3m 39s
  • Locked
    7. 
    Installing Packages to the File System or Instance
    8m 58s
  • Locked
    8. 
    Configuring Package and Project Deployment Security
    5m 33s
  • Locked
    9. 
    Managing the SSIS Catalog
    6m 21s
  • Locked
    10. 
    Using Catalog Stored Procedure and Views for Logging
    6m 16s
  • Locked
    11. 
    Backing Up and Restoring the SSIS Catalog
    3m 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.

YOU MIGHT ALSO LIKE

Likes 14 Likes 14  
Likes 8 Likes 8  
Likes 25 Likes 25  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 57 Likes 57  
Likes 85 Likes 85  
Likes 37 Likes 37