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 on Presentations at Atlanta’s BI Edition SQL Saturday

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 on Advanced Scripting in SSIS

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 on Q & A From “Unit Tests for SSIS Packages”

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?

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 on Checking Whether a Character is Numeric

Naming Columns for the Script Component

Naming columns is important for the Script component Continue reading

Posted in SSIS | Tagged , | Comments Off on Naming Columns for the Script Component

Using OLE DB Connections from Script Tasks

Use OLE DB Connections from Script Tasks in SSIS Continue reading

Posted in SSIS | Tagged , | Comments Off on Using OLE DB Connections from Script Tasks

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)

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