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

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