Author Archives: jwelch

SQLSaturday and Touring the South

I’m sitting in the Seattle-Tacoma airport right, now, waiting for my redeye flight back to Charlotte after a fun and productive week in Seattle. When I get home, I’ll be jumping straight into a car with my family and driving … Continue reading

Posted in SQL Saturday | Tagged , | Comments Off on SQLSaturday and Touring the South

Delivering a Pre-Con at SQLSaturday #89 (#sqlsat89)

Data Warehousing with SSIS Deep Dive at SQLSaturday #89 Continue reading

Posted in SQL Saturday | Tagged , , | Comments Off on Delivering a Pre-Con at SQLSaturday #89 (#sqlsat89)

Presenting at SQLSaturday #82 (#sqlsat82)

Presenting at SQLSaturday #82 Continue reading

Posted in SQL Saturday | Tagged , | Comments Off on Presenting at SQLSaturday #82 (#sqlsat82)

Defining the Data Flow in Biml

Define data flow paths in Biml Continue reading

Posted in SSIS | Tagged , , | Comments Off on Defining the Data Flow in Biml

Controlling the Control Flow in Biml

Learn to define precedence constraints for SSIS in Biml Continue reading

Posted in SSIS | Tagged , , | Comments Off on Controlling the Control Flow in Biml

BIDS Helper 1.5 Is Available!

BIDS Helper 1.5 Released Continue reading

Posted in SSIS | Tagged , , , | Comments Off on BIDS Helper 1.5 Is Available!

Configuring Visual Studio to Play Nicely with BimlScript

Visual Studio has a great XML editor. Unfortunately, it doesn’t understand BimlScript. This can cause a few headaches when using the Biml feature in BIDS Helper, particularly when you copy and paste BimlScript code into the editor. Take this code … Continue reading

Posted in SSIS | Tagged , | Comments Off on Configuring Visual Studio to Play Nicely with BimlScript

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

Submissions for PASS Summit 2011

PASS Summit 2011 Abstracts Continue reading

Posted in PASS | Tagged , | Comments Off on Submissions for PASS Summit 2011