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)

31 Days of SSIS – Environmental Variable(17/31)

It’s time to go back to discussing the environment when it comes to SSIS packages.  For the last few posts of the 31 Days of SSIS series I’ve talked about developing packages.  As important as developing packages is, we must be prepared to develop them in a way that they can be securely deployed. As … Continue reading 31 Days of SSIS – Environmental Variable(17/31)

31 Days of SSIS – 10 Things About Expressions (16/31)

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)

31 Days of SSIS – Every Which Way Outputs (15/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)

31 Days of SSIS – Instant Excel Spreadsheet (14/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)

31 Days of SSIS – Create XML Document (13/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)