blogs.conchango.com

Someone emailed me today asking: I have an SSIS package that outputs data that can’t be inserted into destination tables into flat log files [JT: I presume he means that error rows are redirected to a flat file] What is the easiest way to then after processing has completed: A) Check to see whether there has been any data that could not be ...

Checkpoint usage in SSIS is a topic that is not well understood at all. The mechanism for defining checkpoint files and configuring containers to use them is "fiddly" at best and isn't helped by a bug in the Sequence Container (of which you can read more about here). I hope to find the time to write a definitive article in the near ...

Here's a handy little tip for when you are building custom destination components or script destination components that enables you to log the number of processed rows. Have you ever seen that handy little message that appears in your logs that tells you how many rows arrived at a destination component? It looks a little like ...

Checkpoint files are very useful mechanisms for recovering failed packages and I have talked about them quite a bit before, however, they do have one or two limitations. One thing that people typically want to do is always execute a particular task regardless of whether a checkpoint file exists or not. There may be a number of reasons for this - ...

Many ex-DTS users are miffed that the SSIS expression language does not have an equivalent of the VB Script IsNumeric() function that is used so extensively in DTS and to be honest, its a fair shout. The following code is very typical in DTS packages: If IsNumeric(RetailPrice) = False Then     DTSDestination(''RetailPrice'') ...

I haven't published a nugget for a while but today a guy called Antonio was asking me how one might output the captured rowcount in a file so i thought I'd put something together that demonstrated it. Its very simple, although you will need two data-flows. One to capture the rowcount (using a rowcount component), and another to ...

Visitors to the SSIS forum often ask how to construct a date string in the form YYYYMMDDHHMISS (e.g. "20070207123456" for "7th February 2007, 12:34:56") using a SSIS expression. I always give the same answer so I thought I'd post the answer up here so I don't have to keep typing it. Here's the ...

About a month ago I wrote this very simple blog post explaining how one might go about stripping off the last word from a sentance in the pipeline. My Conchango colleague James Saull thought that this would be ripe for a regular expression (and he's right) and asked if we could we apply regular expressions in SSIS. The answer is ...

In the past I have talked alot about how you can use the script component in a number of different ways. It provides a quick and easy way to add custom, performant functionality to your data-flows. Of late I haven't provided many examples of using the script component but then I read this post on the SSIS forum that asked how to ...

Anyone who reads this blog regularly knows I am a big fan of using expressions to achieve results in SSIS. In this post I'm going to show a very simple example of using them. If you are building SSIS packages then you will be (or you should be) using the log providers to keep a history of your package executions. I generally use the ...