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