I have become accustom to modifying package variables within my Script Task using the VariablesDispenser  object.  It is convenient and powerful.  I started working with this object due to issues I found while hacking my way through SSIS2005.  I would put the variables in the ReadOnly…

Read more

 I have become accustom to modifying package variables within my Script Task using the VariablesDispenser  object.  It is convenient and powerful.  I started working with this object due to issues I found while hacking my way through SSIS2005.  I would put the variables in the ReadOnly…

Read more

I have built an enormous number of packages for this project over the past few weeks (just over 60) and wondered if a conditional split case without a destination was efficient.  I have been using the Conditional Split component with one case going nowhere as a way to 'throw' out… Read more

Views are used quite often within SQL Server for a number of reasons.  They can be used to restrict access to tables (restrict the columns viewable or the records returned) , combine multiple tables into a single 'virtual table', or apply specific sets of formulas(like avg cost or an item).… Read more

Conditional Split is a very powerful component, enabling you to send records in different directions or exclude them from the downstream altogether.  I use this component quite often in my SSIS packages.  In the industry I work in, publishing, there are many times we'll get a file in from…

Read more

Conditional Split is a very powerful component, enabling you to send records in different directions or exclude them from the downstream altogether.  I use this component quite often in my SSIS packages.  In the industry I work in, publishing, there are many times we'll get a file in from…

Read more

I just gave a virtual presentation, courtesy of Pass and the appdev group.  The recorded presentation is available here:

Recorded Presentation

A copy of the slide deck is available in the download section:

Index Statistics

  Read more

I have worked in many industries, but most of my time has been in the publishing industry.  For those not familiar with this industry it is rather interesting.  The main objective is to "sell" as many books as possible to as many retailers and distributors as possible.  I put sell… Read more

There are a few ways to get data from a client to your system; FTP or email.  Internally we tend to use email for two reasons: everyone has it and  it provides an audit trail (I know who sent what and when).  The corporate email standard is MS Outlook, which… Read more

In a previous post I showed you how to access variables from within an SSIS script component.  More specifically I showed you how to access variables from within an Script Destination Component.  You can not access the read/write variables using the standard Dts.VariableDispenser that you are familiar with… Read more

In a previous post I showed you how to access variables from within an SSIS script component.  More specifically I showed you how to access variables from within an Script Destination Component.  You can not access the read/write variables using the standard Dts.VariableDispenser that you are familiar with… Read more

 I am excited to say I have been published on Simple-Talk.  This was my first foray into being professionally edited.  I will say the experience was not what I imagined.  I guess everyone has different ideas of what it is like to have an editors review your…

Read more

 I am excited to say I have been published on Simple-Talk.  This was my first foray into being professionally edited.  I will say the experience was not what I imagined.  I guess everyone has different ideas of what it is like to have an editors review your…

Read more

I have been trying for a few days to implement a Service Broker implementation to, service the threading framework I built for SSIS.  When you build the threading framework you have a set number of threads running and I have been looking for a way to modify the number of… Read more

I have been trying for a few days to implement a Service Broker implementation to, service the threading framework I built for SSIS.  When you build the threading framework you have a set number of threads running and I have been looking for a way to modify the number of… Read more

 In a previous post I explained how to trap for errors in your Script Task and Components and send the information to the SSIS Log (link).  A good friend of mine and system engineer extraordinaire Eugene L. (last name withheld to protect the guilty :) ) suggested that…

Read more

 Using a Try/Catch/Finally within your Script Components and Script Tasks is just good coding practice.  The thing you want to be able to do is push any errors you trap to a log file.  The syntax is somewhat simple, but it took me some…

Read more

I am always looking to improve the performance of my SSIS packages.  I try to do as much work within the package as possible, only going to external stores (databases, flat/raw files) as little as possible.  There are a number of reasons for this.  Raw files are incredibly fast and…

I am always looking to improve the performance of my SSIS packages.  I try to do as much work within the package as possible, only going to external stores (databases, flat/raw files) as little as possible.  There are a number of reasons for this.  Raw files are incredibly fast and…

In this article I will show you how to implement a stack.  In programming, stacks are a great way to manage data or work.  Everyone pulls from the same pool and there is no duplication (once a unit is pulled off the stack, it is no longer available to any…