O'Reilly logo

SQL Server 2017 Integration Services Cookbook by Dejan Sarka, Matija Lah, Christian Cote

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

How to do it...

The steps will be essentially similar to the ones used to deploy the source database. Since we explained most of the steps previously, this recipe will be more concise:

  1. The DB.AdventureWorksDW project contains the following schemas:
    • Cube: This contains specific database objects, mainly views that can be used by an SSAS cube.
    • dbo: This the default schema.
    • DW: This folder contains database objects that belong to the DW schema, that is, the data warehouse star schema objects.
    • Scripts: This is a folder that holds pre or post-deployment scripts, as well as utility scripts.
    • Staging: This folder contains database objects used by the Staging schema.
    • SystemLog: This folder contains database objects used by the SSIS framework. We'll ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required