Vague SSIS error message — SSIS Error Code DTS_E_PROCESSINPUTFAILED

Eugene Niemand
Oct 2, 2014 · 2 min read

So today I got the error message below

So this happened when I passed some names through RegEx in a script task to split it into different parts. If you look at the error there are some things that stand out:

  • NullReferenceException: Object reference not set to an instance of an object.
  • Parse Scorecard Name into properties
  • Input 0

Ok, so this sort of points me in the direction of where the error happened, well at least which task caused it. In my script task I’m setting the values of 4 output columns with the results of different RegEx expressions. Now you will notice this error does not point to the line in the code or which function it was. The only thing I had to go by was the “object reference…” message. This led me to looking for working with an object that could potentially be null when I’m trying to manipulate it. Eventually I found it, I was referencing the Length property on a string with a null value in an If Statement, but I did not expect it to be a null value. To fix it, I just had to add “myStrProp != null” to test nullability first before accessing the Length property. This is a very common error in C# programming and easy to fix. I just wish the error messages from SSIS script components gave a better message as to where the error is.

Eugene Niemand’s Blog

Technology and Programming professional and enthusist

Eugene Niemand

Written by

Senior Data Engineer at ASOS.com - I have a passion for Test Driven Development, Agile Methodologies, Continuous Integration and Delivery using Microsoft Azure

Eugene Niemand’s Blog

Technology and Programming professional and enthusist