Category: SSIS

Every now and then you come across something you don’t want to deal with that you’re forced to handle in your SSIS packages. Here Continue reading “Dealing with Sql_variant in SSIS”

Intro to SSIS.

Inspired by a user question I decided to make a quick vid on how to use a script task to check that a file exists. Continue reading “Check if File Exists”

This is a nice little primer on designing clean packages that are easier to support. Get rid of the sea of arrows that afflict Continue reading “Clean Package Design”

In this 2nd class we discuss how to decide whether you should architect your table loads in single or multiple packages. We also start Continue reading “Ground Zero SSIS: Class 2”

This is a live troubleshooting video. I had an error importing an SSIS pkg so I turned on the camera and worked the issue Continue reading “Fix SSIS Pkg Import Errors”

Jen and I sit up very late one night and discuss how do deploy SSIS packages. If you don’t know anything at all about Continue reading “Deploy Packages”

Here I show you how to work with derived columns in SSIS and use it to not only marry columns, but also troubleshoot data flows. Continue reading “Derived Columns”

Here I show you how to put your data source connection string inside a package configuration XML file. This was inspired by a forum post Continue reading “Connection strings in Package Config Files”

This one was by user request to show how you can compare the counts of 2 tables and use it to force the package to Continue reading “Forcing Package Failures”

There is a lot of tribal knowledge that accumulates in any organization. Here I discuss some ways to document your SPs so you can Continue reading “Commenting Tribal Knowledge in SPs”

This video discusses how to pass parameters to queries and SPs inside the Execute SQL Task. It doesn’t teach the basics of the task. Continue reading “Execute SQL Task with Parameters”

Here I discuss how to use the row count transform in SSIS and give you some good advice for naming and working with the variable Continue reading “Row Count Transform”

Here I talk about how to setup the script task to work with variables, and how to access them through code once the script can Continue reading “SSIS Using Variables in Script Tasks”

Here I show you the basics of how to work with ForEach loops. Good stuff.

Here I take the intro one step further and show you how to create multiple txt files based off of a looping variable in the Continue reading “Creating Files with ForEach Loop”

This video takes a look at the basics of using the Sequence Container in SSIS. There’s not a lot to it, but it’s a Continue reading “Introduction to Sequence Containers”

There is a lot of tribal knowledge that accumulates in any organization. Here I discuss some ways to document your SSIS packages so you Continue reading “Commenting Tribal Knowledge in SSIS Packages”

This is a live presentation I gave recently. Here is a bare bones bottom of the barrel discussion on SSIS. This is for Continue reading “SSIS Basics”

Here we’re just going to jump into SSIS and do some real practical work. We’re going to learn all about taking things to/from multiple Continue reading “SSIS Basics 2: Flatfile Olympics”

Learn how SSIS scopes variables. It’s not a complicated topic, but worth covering.

Here I talk about how to use the multiflatfile connection manager in SSIS to loop through flatfiles.

Fix data errors with derived cols and conditional split transformations.