blogs.conchango.com

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 ...

Have you ever had the requirement to output data from a data-flow as a CSV file or an XML file where the choice is dependant on the file extension of your destination file? Well, David Bulog (also known by the pseudonymn ''Mr Pro Tools'') has and he has posted his code to do this here. I think David went through a bit of trauma to get this ...

I thought it would be worth publishing a list of guidelines that I see as SSIS development best practices. These are my own opinions and are based upon my experience of using SSIS over the past 18 months. I am not saying you should take them as gospel but these are generally tried and tested methods and if nothing else should serve as a basis ...

The SSIS script component rocks, don't you think? I think I might have made this point before on 4 or 5, possibly a few hundred, occasions. The ability it gives you to incorporate the power of the .Net framework and your own assemblies into the SSIS pipeline can't be overstated - it puts SSIS head and shoulders above any other enterprise ...

It is generally accepted that a synchronous script component outputs the same number of rows as are input. Well I have news for you, this doesn't have to be the case. If you have a synchronous script component with multiple outputs then you can choose to send each input row to many or none of these outputs. As a result it is possible to have a ...

UPDATE: Check out kdog's useful comments at the bottom as well! Script components can either be synchronous or asynchronous. There are a number of definitions about the difference between the two including a description that I posted back in February. I thought it would be useful to demonstrate the difference between synchronous and ...

Another quick nugget here to demonstrate Regular Expressions. For those that don't know, regular expressions are a nifty way of matching incoming textual values to a required format. Probably best that I don't try and explain it any more. Read on... One of the classic demo uses of regular expressions is to examine a UK postcode to see if it ...

Ever wondered how you can generate surrogate keys in a SQL Server Integration Services (SSIS) data-flow? Well here on SQLIS.com is just 1 method you can use - the script component! Let me know if this works for you or not. -Jamie  

UPDATE 2006-03-14: This information in this post should now be disregarded. Read here: http://blogs.conchango.com/jamiethomson/archive/2006/01/04/2540.aspx instead! It is possible to populate an SSIS variable of type ''Object'' with a recordset using the ''Recordset Destination'' data flow destination component. Thereafter there are various ways ...