31 Days of SSIS – Small Package, Big Win (26/31)

Welcome to day twenty-sixth post of the 31 Days of SSIS.   We’re getting near the end now.  If you have not read the other posts, they can be found through the introductory post. This series has been a combination of my thoughts on practices for working with SSIS and proof of concept packages that represent … Continue reading 31 Days of SSIS – Small Package, Big Win (26/31)

Presenting on #SSIS to EDMPASS Today

Will you be in Edmonton today?  How about near a computer connected to the inter-tubes?  If so, you might be interested in joining the EDMPASS January user group meeting.  Colin Stasiuk (Blog | @BenchmarkIT) invited me to join the meeting today. The details for the meeting are Start Time: Wednesday, Jan 26, 2011 6:00 PM … Continue reading Presenting on #SSIS to EDMPASS Today

31 Days of SSIS – One Package, Unlimited Tables (25/31)

One day at a time and we have reached the twenty-fifth post in the 31 Days of SSIS.   If you enjoy this post, take a look at other posts in this series.  They can be found through the introductory post. Yesterday’s post demonstrated an SSIS package that connected one package to unlimited databases.  For today, … Continue reading 31 Days of SSIS – One Package, Unlimited Tables (25/31)

31 Days of SSIS – One Package, Unlimited Databases (24/31)

Another day, another blog post all about SSIS in my continuing journey through 31 Days of SSIS.  A list of the other posts in this series can be found in the introductory post.  If you haven’t had a chance to read through that, I would recommend taking a look at it after reading this post.  … Continue reading 31 Days of SSIS – One Package, Unlimited Databases (24/31)

31 Days of SSIS – Generating Row Numbers (23/31)

It’s Sunday afternoon and a good time to be putting up post twenty-three for the 31 Days of SSIS blog series.  A list of the other posts in this series can be found in the introductory post.  If you haven’t had a chance to read through that, I would recommend taking a look at it … Continue reading 31 Days of SSIS – Generating Row Numbers (23/31)

31 Days of SSIS – Data Flow Expressions (22/31)

Today, we continue on with the 31 Days of SSIS blog series.  Yesterday’s post was on the use of expressions with Precedence Constraints and how to control the Control Flow.  Today, we’ll venture a little further in with the use of expressions, and a head into the Data Flow and how you can use expressions … Continue reading 31 Days of SSIS – Data Flow Expressions (22/31)

31 Days of SSIS – Controlling Your Flow In The Control Flow (21/31)

Remember, what I said last Friday?  I’m going do it, again.  Which means, I’m taking the day off.  There will still be a 31 Days of SSIS post, you’re reading it right now. This post was being written by Chris Fish (LinkedIn).  He’s another of my co-workers at Digineer and and is on the team … Continue reading 31 Days of SSIS – Controlling Your Flow In The Control Flow (21/31)

31 Days of SSIS – No More Procedures (20/31)

Time to shift off of configurations and environments and talk more about SSIS packages and best practices.  If you haven’t been following this series and are just joining in, we are at day 20 of the 31 Days of SSIS.  Now that is out of the way, let’s move on. Today, we are going to … Continue reading 31 Days of SSIS – No More Procedures (20/31)

31 Days of SSIS – DTSConfig Configuration (19/31)

The last two posts in the 31 Days of SSIS talked about the use of environmental variables and SQL Server configurations.  Between those two types of configurations, you can cover most situations where you need to configure an SSIS package. There is one more type of SSIS package configuration that I’d like to make sure … Continue reading 31 Days of SSIS – DTSConfig Configuration (19/31)

31 Days of SSIS – SQL Server Configuration (18/31)

The last post in the 31 Days of SSIS talked about the use of environmental variables.  As I mentioned in that post, environmental variables are great for values that are specific to individual environments One problem with environmental variables that I mentioned is often the operating system needs to be rebooted after adding new environmental … Continue reading 31 Days of SSIS – SQL Server Configuration (18/31)