Category Archives: SSIS

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

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

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

BIDS Helper 1.5 Is Available!

BIDS Helper 1.5 Released Continue reading

Posted in SSIS | Tagged , , , | Comments Off

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

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

Creating Tables using Biml and BimlScript

Create tables using Biml and BimlScript Continue reading

Posted in SSIS | Tagged , , , | Comments Off