Introduction This is the first in a series of posts describing how to use EzAPI to generate SSIS Packages. This is the classic ‘Hello World’ example describing the very basic getting started usage of ezAPI. The article first describes the simple ‘Hello World’ example then describes a ‘Hello World’ example incorporating Dimodelo Data Warehouse Studio design…
Let’s say, in an SSIS Data Flow which is processing invoices, you wanted to match an invoice to an event based on the date of the invoice falling between the start and end date of the event. To achieve this in a SSIS Lookup Transformation, you need to use advanced configuration. The configuration steps required follow: On…
This post discusses in detail how Dimodelo Data Warehouse Studio generates code to create and manage a Data Warehouse, including creating and managing Data Warehouse Databases, Tables and ETL procedures. While Dimodelo Data Warehouse Studio has a set of predefined Generation Templates and Generation Providers , it is also extensible, allowing end users to create their own Generation Templates and Generation Providers.
If you thought you could override an SSIS package’s configurations when running it through an SQL Server 2008 R2 Job… think again. In the SQL Server Job Step Properties dialog, there is a Configuration tab that allows you to specify configuration files. The logical assumption is that this will override existing configurations with the same…
Here at Dimodelo Solutions we often work remotely. With today’s technology, we can use Virtual Private Network (VPN) technology to securely connect into our client’s network and access their Servers, as if we were there on site. All that is required is the appropriately authorized Server credentials (User Name and Password) and a VPN Server configured at the client site. Today,…
While conventional wisdom (and Kimball) says that using meaningful identifiers for surrogate keys is a bad idea, there are some exceptions where it makes sense. Typical examples include: Calendar. An example of a Calendar smart key is – year, month, day e.g. 20110721. A DateTime value can be converted to this date format using this statement convert(char(8),date, 112)….
What is a derived staging table? It’s a table created in your Staging database that derives its data from other already existing Staging tables. Its useful for creating aggregations, or allocations of data prior to the transform and load process into your Data Warehouse. It can also be useful for tables that don’t have any…
This article discusses how to add a Custom SSIS Component to the SSIS Tool Box in Visual Studio, so you can use it in your Control or Data Flows. Custom components are often distributed as DLL files, so some manual installation is usually required. 1. Add the DLL to your system The SSIS BIDS toolbox locates components…
To add an Existing Dimension to an SSAS Project Right click the project node in Solutions Explorer. Select Add>Existing Item. Navigate to the dimension file (wherever it may be), select it and click add. A copy of the dimension is copied into your SSAS project root directory, and added to the project. A Dimension is…
