Welcome to EMC Consulting Blogs

September 2007 - Posts

• Astoria for SSIS

  I have been talking about Astoria on this blog for some time now. For those who don't know what Astoria is the 50000ft view of it is that its a technology that allows us to expose data over HTTP thus anything that talks HTTP can consume the data. HTTP Read More... Posted 29 September 2007 19:13 by jamie.thomson | 2 Comments Filed under: SQL Server Integration Services, SSIS, Astoria, ADO.Net Data Services

• SSIS: Normaliser Component bug fix

  17 days ago I released my Normaliser Component but embarrassingly it turns out there was a small bug. Any null values in the sorted columns on the component input would cause the component to throw a nasty unhandled error. I've fixed the bug in v1.1 which Read More... Posted 25 September 2007 05:44 by jamie.thomson | 7 Comments Filed under: SQL Server Integration Services, SSIS, Dataflow Task

• Astoria and Web3S converge

  Three weeks ago I wrote this blog entry that raised a question mark over why Microsoft were coming out with two seemingly contradictory RESTful APIs (Astoria and Live Data) for exposing data. I linked to this forum posting where Federico Raggi from Microsoft Read More... Posted 20 September 2007 23:40 by jamie.thomson | 1 Comments Filed under: Windows Live, Data Integration, Astoria, ADO.Net Data Services

• MDM axioms

  This week The Galloping Data Architect and I are attending the Gartner MDM conference in Hollywood, Florida. As the week has gone on I've been making a note of quotes that I hear or conclusions that I draw myself whilst listening to the various speakers Read More... Posted 20 September 2007 23:07 by jamie.thomson | 3 Comments Filed under: Data Architecture, Data Integration, MDM, Master Data Management

• New article on SSC

  Just a quick blog entry here to let you know that an article of mine has today been published on SQL Server Central entitled "Experiences from a Real World Project". Go here: http://www.sqlservercentral.com/columnists/jthomson/3219.asp if you want to Read More... Posted 20 September 2007 22:59 by jamie.thomson | 0 Comments

• Datadude: New unannounced feature in SR1

  Service Release 1 of Visual Studio 2005 Team Edition for DB Pros (aka datdude) includes a new feature that hasn't been mentioned anywhere by the datadude team. Any database deployed using SR1 will contain an extended property called 'microsoft_database_tools_deploystamp'. Read More... Posted 10 September 2007 22:41 by jamie.thomson | 3 Comments Filed under: Visual Studio Team System For Database Professionals, datadude

• SSIS: What improvements would you like to see to debugging?

  Back in December 2006 I added a posting to Connect requesting enhancements to the debugging features within the SSIS designer. Here's what I had to say: Problem Description: I had a problem today when using SSIS that took me literally a few hours to solve. Read More... Posted 08 September 2007 02:45 by jamie.thomson | 14 Comments Filed under: SQL Server Integration Services, SSIS

• SSIS: The Normaliser Component

  Scene Setting Its a common scenario when doing data integration that one has to process datasets containing redundant data. In many cases this is when data is received in flat files and all data is put into a single file for ease of transport. Perhaps Read More... Posted 07 September 2007 20:16 by jamie.thomson | 9 Comments Filed under: SQL Server Integration Services, SSIS, Dataflow Task, video

• SSIS: Generic method for populating a pipeline buffer column

  Careful Sidney! There's some C# code in Jamie's latest blog post :) Yesterday I posted this blog post explaining some of the particulars regarding the various Set*() methods of the PipelineBuffer class. In that post I half-promised that I would Read More... Posted 06 September 2007 05:00 by jamie.thomson | 3 Comments Filed under: SQL Server Integration Services, SSIS

• SSIS: Obscure bug when developing custom components.

  I've found a bug in SSIS today ( confirmed by Bob Bojanic from the SSIS team) but it shouldn't have any cause for alarm. Its a very obscure circumstance that causes it and isn't too much of a problem either. However, I thought it would be Read More... Posted 05 September 2007 21:26 by jamie.thomson | 1 Comments Filed under: SQL Server Integration Services, SSIS, Dataflow Task

• SSIS: PipelineBuffer.Set*() methods

  If you are building asynchronous custom components for SSIS then at some point you will need to use the various Set*() methods of the PipelineBuffer class to populate data into the output buffer. There are a lot of these set methods but the documentation Read More... Posted 05 September 2007 08:31 by jamie.thomson | 1 Comments Filed under: SQL Server Integration Services, SSIS, Dataflow Task

• SSIS: Problems executing out-of-process

  Hi, I've been suffering some infuriating teething troubles with SSIS today and thought it would make sense to write about them in case a) someone else runs into the same problems and more importantly b) I run into them again(!!!) In short, we have Read More... Posted 04 September 2007 23:26 by jamie.thomson | 9 Comments Filed under: SQL Server Integration Services, SSIS