IN2BI, Microsoft Business Intelligence
data, stories & insights
rss | email | twitter

DWH Deck 2.0: Step 3 Publish the jobs to create the SQL Statements and BIML Files

The DWH Deck is a simple tool that allows you to build and maintain your data warehouse better and faster.

In previous blog posts we created connections and jobs that describe the source to target mapping. In this blog post we’ll examine the effects of publishing the jobs.

  • Click Publish on the menu bar
  • Check the created files in (default location:) C:\in2bi\DWHDeck
  • Check the created tables and stored procedures in the NorthwindDW1 database.

image

image

In this step we examined the effects of publishing the jobs: The SQL statements that are executed and the BIML files that are build.
In the next post I’ll describe how you create SSIS Packages from these BIML files.

Overview of the DWH Deck 2.0

» Similar Posts

  1. DWH Deck 2.0: Step 4 Create SSIS packages from the created BIML Files
  2. DWH Deck 2.0: Step 2 Add Jobs by selecting source objects and applying a template
  3. DWH Deck 2.0: Step 1 Create solution database and other connections

» Trackbacks & Pingbacks

    No trackbacks yet.

» Comments

    There are no comments.

Comments are closed