Welcome to EMC Consulting Blogs

January 2008 - Posts

• Some Analysis Services stuff!

  Its a while since I spoke about Analysis Services on here but today I was getting back into the SSAS groove in a couple of ways. Firstly, I received an email from Microsoft Connect in reply to one of my old suggestions which I opened back in June 2006. Read More... Posted 30 January 2008 04:15 by jamie.thomson | 9 Comments Filed under: SQL Server Analysis Services, Microsoft, MDM, Master Data Management, ssas

• SSIS: How to use .Net assembly configuration files in the script task

  A couple of work colleagues had a problem when using SSIS yesterday which took a bit of working out so I thought I'd share it here, it'll be useful for anyone else that has the same problem. It was all to do with calling .Net assemblies (i.e. DLLs) from Read More... Posted 25 January 2008 23:59 by jamie.thomson | 10 Comments Filed under: SQL Server Integration Services, SSIS, Scripting

• SSIS: Hiding columns in the pipeline

  Yesterday I received an email from a SSIS developer asking questions about some peculiarities of SSIS. One of the points she raised was thus: I found i spent alot of time trying to figure out how to get rid of un-needed fields in the flow. Not all transforms Read More... Posted 16 January 2008 02:12 by jamie.thomson | 2 Comments Filed under: SQL Server Integration Services, SSIS, Dataflow Task

• SSIS: ExclusionGroup

  A message was posted on the SSIS forum earlier today asking about ExclusionGroups. BOL is a little light on the subject of why you might use Exclusion Groups so I thought I would elaborate here a little. An ExclusionGroup can be used by synchronous components Read More... Posted 05 January 2008 23:22 by jamie.thomson | 0 Comments Filed under: SQL Server Integration Services, SSIS, ExclusionGroup