Sixteen days in and we are past the half way point for the 31 Days of SSIS blog series. In a few of the previous post I made reference to the use of the expression language within SSIS. Today I'm going to cover ten things that you should probably know about them. The SSIS expression … Continue reading 31 Days of SSIS – 10 Things About Expressions (16/31)
Saturday morning and you can watch your favorite cartoon, or jump into some fun with SSIS. Today is the fifteenth day of the 31 Days of SSIS. This month I'm writing blog posts that cover some of the things I’ve learned and development techniques that I’ve used with SSIS. One of my favorite transformations to … Continue reading 31 Days of SSIS – Every Which Way Outputs (15/31)
It’s day fourteen of the 31 Days of SSIS blog series. It’s also Friday, so I’m taking the day off. That doesn’t mean that there won’t be a post today. What it means is that I have asked Aaron Drinkwine (LinkedIn), one of my co-workers at Digineer, to write a post for today. This post … Continue reading 31 Days of SSIS – Instant Excel Spreadsheet (14/31)
Day thirteen and we are trucking along with the 31 Days of SSIS blog series. The last couple posts discussed methods that could be used to unpivot (1, 2) data to populate data into an entity-attribute-value (EAV) architecture. Package Requirements Sometimes, though, it isn’t necessary to populate customer data that doesn’t fit into the portion … Continue reading 31 Days of SSIS – Create XML Document (13/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)
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)
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)
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)
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)
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)
Strate SQL 