blogs.conchango.com

I have just received an email from Donald Farmer, Group Program Manager for SSIS, who took great delight in telling me that his product has claimed the title of "Best ETL Software" in the Techweb Readers' Choice Awards. I don't usually take much notive of award ceremonies (those god-awful celeb-kiss-@rse award ...

Here is the next in my series of posts explaining how common tasks in DTS can now be implemented in SSIS.Use multiple connection objects in order to maintain seperate connections to a database It was commonly recommended in DTS that a package should contain multiple connection objects pointing to the same database if you had multiple ...

Many people like to use stored procedures as the source of data for the SSIS pipeline. In theory there is nothing wrong with that however it does have its complications. Depending on the way the stored procedure is written, it may or may not be suitable to be used in this way. Namely, it is possible to preview the data being returned from a stored ...

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

One of the great selling points of ETL tools such as SSIS is that is is possible to move data from source to destination without "touching disk" as they say. By this I mean that data can be extracted from source and inserted into a destination without having to stage it anywhere first. Transformations and aggregations can be applied to ...

So there I was sitting the Upgrading to SQL 2005 one-day course last week and along with all the why upgrade and considerations when you upgrade questions, there was one question that I realised that EVERY single person in the group wanted to know about: Exactly what is the deal with DTS packages when you upgrade to SQL Server 2005?  Since ...

It is a very common scenario to be able to load two tables in the same data-flow that have a foreign key relationship between them. The question of how to do this gets raised very often on the SSIS forum so I figured I'd try and address it here. Basically, its not possible to do this without using a workaround. There are two possible workarounds ...

Did you know.... ...that you can run regular SQL Server transactions in SSIS over multiple tasks without requiring the use of Distributed Transaction Coordinator (DTC)? Well I didn't but thanks to that man again, Kirk Haselden, I do now. The default behaviour of a Connection Manager is that every task has its own connection which is why they ...

I was asked at a recent Conchango SQL Server community session how much memory SQL Server Integration Services (SSIS) was able to use and I had to confess that although I had an inkling about the 3GB Windows limit I didn't know the full details. Thankfully Ash Sharma did and he supplied the following info: On 32bit ...