Tag Archives: Automation

Follow Up for Continuous Delivery Presentation at CBIG

I presented Continuous Delivery for Data Warehouses and Marts at the Charlote BI Group Tuesday night. They have a great group there and I look forward to going back. This is one of my favorite topics, and I always get … Continue reading

Posted in Presentations, SSAS, SSIS, User Groups | Tagged , | Comments Off on Follow Up for Continuous Delivery Presentation at CBIG

Where’s John These Days?

Apologies for the lack of updates to the blog recently. It’s been a very busy time, but hopefully things will settle down a bit now. Exciting news today (for me at least)! It was my first day as a Pragmatic … Continue reading

Posted in Events | Tagged , , | Comments Off on Where’s John These Days?

Copy Data Dynamically with BimlScript

This post is part 3 of a series on using Biml in BIDS Helper. This post builds on some of the information and the sample from the previous posts. BimlScript enables some interesting scenarios for generating large numbers of SSIS … Continue reading

Posted in SSIS | Tagged , , | Comments Off on Copy Data Dynamically with BimlScript

Creating Tables using Biml and BimlScript

Create tables using Biml and BimlScript Continue reading

Posted in SSIS | Tagged , , , | Comments Off on Creating Tables using Biml and BimlScript

Creating a Basic Package Using Biml

Create an SSIS package using Biml in BIDS Helper Continue reading

Posted in SSIS | Tagged , , , | Comments Off on Creating a Basic Package Using Biml

Using MSBuild with SQL Server Analysis Services Projects

I’ve written several blogs and community samples on working with SSAS Projects directly using AMO (instead of SSAS Databases on an Analysis Services server).  I was travelling this weekend, and got a chance to create a sample MSBuild task that … Continue reading

Posted in Uncategorized | Tagged , | Comments Off on Using MSBuild with SQL Server Analysis Services Projects

Validating SSAS Projects Programmatically

Earlier this week I got a feature request from someone someone that was looking in to my SsasHelper sample on the Microsoft SQL Server Community Samples:  Analysis Services site on CodePlex.  She was interested in Building a SQL Server Analysis … Continue reading

Posted in Uncategorized | Tagged , | Comments Off on Validating SSAS Projects Programmatically