Tag Archives: SSIS

Presentations at Atlanta’s BI Edition SQL Saturday

I presented this weekend at SQL Saturday #477 in Atlanta. It was a great event, very well organized. I appreciate all the attendees at my sessions – there were some great questions and comments. I promised that I’d publish my … Continue reading

Posted in Presentations, SQL Saturday | Tagged , , | Comments Off

Advanced Scripting in SSIS

Last week I presented a session on Advanced Scripting for SSIS for Pragmatic Works. Thanks to everyone who attended, and all the great questions. I’ve had a few requests for the samples I used, so I wanted to make those … Continue reading

Posted in Presentations, SSIS | Tagged , , | Comments Off

Q & A From “Unit Tests for SSIS Packages”

I did a webinar this week for Pragmatic Works’ “Free Training on the T’s”. The topic was “Unit Tests for SSIS Packages”. If you attended, thanks for taking the time! If not, the recording is now available at the link … Continue reading

Posted in Presentations, SSIS | Tagged , | Comments Off

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

Checking Whether a Character is Numeric

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

Naming columns is important for the Script component Continue reading

Posted in SSIS | Tagged , | Comments Off

Using OLE DB Connections from Script Tasks

Use OLE DB Connections from Script Tasks in SSIS Continue reading

Posted in SSIS | Tagged , | Comments Off

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

Defining the Data Flow in Biml

Define data flow paths in Biml Continue reading

Posted in SSIS | Tagged , , | Comments Off

Controlling the Control Flow in Biml

Learn to define precedence constraints for SSIS in Biml Continue reading

Posted in SSIS | Tagged , , | Comments Off