Author Archives: jwelch

Where’s John These Days?

Posted on February 20, 2012 by jwelch

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

Checking Whether a Character is Numeric

Posted on August 30, 2011 by jwelch

Check whether a specific character is numeric in an SSIS expression Continue reading →

Posted in SSIS | Tagged , | Comments Off

Naming Columns for the Script Component

Posted on August 18, 2011 by jwelch

Naming columns is important for the Script component Continue reading →

Posted in SSIS | Tagged , | Comments Off

Using OLE DB Connections from Script Tasks

Posted on August 17, 2011 by jwelch

Use OLE DB Connections from Script Tasks in SSIS Continue reading →

Posted in SSIS | Tagged , | Comments Off

SQLSaturday and Touring the South

Posted on July 29, 2011 by jwelch

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

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

Posted on June 27, 2011 by jwelch

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

Posted in SQL Saturday | Tagged , , | Comments Off

Presenting at SQLSaturday #82 (#sqlsat82)

Posted on June 23, 2011 by jwelch

Presenting at SQLSaturday #82 Continue reading →

Posted in SQL Saturday | Tagged , | Comments Off

Defining the Data Flow in Biml

Posted on June 15, 2011 by jwelch

Define data flow paths in Biml Continue reading →

Posted in SSIS | Tagged , , | Comments Off

Controlling the Control Flow in Biml

Posted on June 13, 2011 by jwelch

Learn to define precedence constraints for SSIS in Biml Continue reading →

Posted in SSIS | Tagged , , | Comments Off

BIDS Helper 1.5 Is Available!

Posted on June 9, 2011 by jwelch

BIDS Helper 1.5 Released Continue reading →

Posted in SSIS | Tagged , , , | Comments Off