31 Days of SSIS – UnPivot Alternative (12/31)

This is the twelfth post in the 31 Days of SSIS blog series.  This post is going to go through solution that I sometimes use as an alternative to the Unpivot transformation.  Probably not too surprising, this solution is going to take advantage of raw files. The Unpivot transformation is a relatively easy transformation to … Continue reading 31 Days of SSIS – UnPivot Alternative (12/31)

31 Days of SSIS – UnPivot Transformation (11/31)

The last post discussed the Pivot transformation – that leads us to this post which will be on the Unpivot Transformation.  Part of the reason I had been trying to fit the the Pivot transformation into the issue I was having was also because I knew how to use the Unpivot transformation and thought I … Continue reading 31 Days of SSIS – UnPivot Transformation (11/31)

31 Days of SSIS – Pivot Transformation (10/31)

A few months back, well before the 31 Days of SSIS started, I had been playing with the Pivot Transformation.  The transformation seemed to fit an issue that I was working through.  After getting to a point where I wanted to smash my computer I finally figured out how to use it and thought this … Continue reading 31 Days of SSIS – Pivot Transformation (10/31)

31 Days of SSIS – Override Variables (9/31)

Day number 9 of the 31 Days of SSIS.  If you missed the first week then start by reading the introductory post.  Since it is Sunday, I’m going to go with something a little lighter and shorter – or at least that’s the expectation as this starts. In a previous post, I discussed variables and … Continue reading 31 Days of SSIS – Override Variables (9/31)

31 Days of SSIS – Merge Join Is My Friend (8/31)

Welcome to day eight post for the 31 Days of SSIS.  If you are just joining the series you may want to read the introductory post.  In another post I talked about the raw file format for sources and destinations. In this post, I want to discuss a solution I worked on where I used … Continue reading 31 Days of SSIS – Merge Join Is My Friend (8/31)

31 Days of SSIS – What The Sorts?! (7/31)

Welcome to day seventh day of the 31 Days of SSIS.  If you are just joining the party you may want to read the introductory post.  In yesterday’s post the SSIS package contained a couple Sort Transformations.  Since they’ve now appeared in a package it seems it would be a good idea to talk about … Continue reading 31 Days of SSIS – What The Sorts?! (7/31)

31 Days of SSIS – Recursive SSIS Package (6/31)

As I mentioned in the introductory post, I’m writing 31 Days of SSIS.  In the first post I talked about the raw file format for sources and destinations. Today, I am going to discuss a solution that I implemented that use raw files for performing a recursive operation within an SSIS package to build an … Continue reading 31 Days of SSIS – Recursive SSIS Package (6/31)

31 Days of SSIS – One Variable to Rule Them All (5/31)

Hopefully by now you’ve read the introductory post for the 31 Days of SSIS series that I am writing.  Today we are going to look at variables in SSIS packages. This post assumes that you already know a bit about variables in SSIS packages.  If there is a groundswell of requests, I can do a … Continue reading 31 Days of SSIS – One Variable to Rule Them All (5/31)

31 Days of SSIS – Folder Structures (4/31)

Hopefully by now you’ve read the introductory post for the 31 Days of SSIS series that I am writing.  Today we will talk about something completely fuzzy and outside of the development environment.  We’re talking about folder structures!  Wahoo! I have often needed to consult with clients on how to setup the SSIS environment.  For … Continue reading 31 Days of SSIS – Folder Structures (4/31)

31 Days of SSIS – Data Flow Breakpoints?! (3/31)

As I mentioned in the introductory post, I’m writing 31 Days of SSIS.  In yesterday’s post I talked about Using Breakpoints.  One of the points I stressed was that breakpoints only exist in the Control Flow and not in the Data Flow.  Today, I’m going to show you that I’m a liar.  But not really. … Continue reading 31 Days of SSIS – Data Flow Breakpoints?! (3/31)