|

Generating SSIS Packages using ezAPI – Hello World

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…

Range Lookups in the SSIS Lookup Transformation

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…

The Dimodelo Data Warehouse Studio code generation process

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.

|

Override SSIS package configurations through an SQL Server 2008 R2 Job

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…

Connecting to Client's Servers via VPN

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,…

How to add a custom SSIS component to Visual Studio Tool Box

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…