Welcome to EMC Consulting Blogs

February 2005 - Posts

• SSIS: Dynamic modification of SSIS packages

  A common feature of DTS packages is that they can be dynamically edited at runtime. This is accomplished by using ActiveX script code to alter the DTS package which is in itself an instance of the DTS Object Model. Once you have access to that object Read More... Posted 28 February 2005 23:02 by jamie.thomson | 78 Comments Filed under: SQL Server Integration Services, SSIS, Scripting, Expressions

• SSIS: Forrester run the rule over SQL Server Integration Services.

  Forrester, the technology research and information company, have released a document reviewing SQL Server Integration Services (SSIS), Microsoft's impending entry into the Enterprise ETL market. The document can be viewed here although you have to pay Read More... Posted 28 February 2005 15:36 by jamie.thomson | 3 Comments Filed under: SQL Server Integration Services, SSIS

• SSIS: SQL Server 2005 Editions and pricing

  Microsoft have released edition and pricing information for SQL Server 2005 and it has some noteworthy ramifications for Integration Services. There are 4 editions: Enterprise Standard Workgroup Express Most notable is that fact that standard ETL functionality Read More... Posted 28 February 2005 09:17 by jamie.thomson | 0 Comments Filed under: SQL Server Integration Services, SSIS

• The OLAP Report

  The latest version of The OLAP Report has just been released. For those that don't knkow this is an annual (I think) report that is produced by Nigel Pendse. It is accepted as the most accurate guide as to the the worldwide OLAP market and covers operating Read More... Posted 23 February 2005 14:05 by jamie.thomson | 1 Comments Filed under: SQL Server

• ROW_NUMBER() Function

  There is a new feature in SQL Server 2005 that is akin to the ROWNUM function in Oracle which I am going to blog about here. I'm sure alot of people reading will already know about this function and its syntax/behaviour but this post may still serve as Read More... Posted 16 February 2005 21:11 by jamie.thomson | 33 Comments Filed under: SQL Server 2005

• SSIS: The new ETL Paradigm

  This is just a short note with a link to a new article of mine that has just been published on SQLServerCentral.com . The article is an attempt to explain to existing DTS developers the most fundamental change that they will have to cope with when moving Read More... Posted 15 February 2005 08:35 by jamie.thomson | 5 Comments Filed under: SQL Server Integration Services, SSIS

• SSIS: SQL Server Maintenance Plans implemented in Integration Services

  I have been idly flicking through the latest edition of SQL Server Standard and was reading an article called "Best SQL Server 2005 Features for DBAs" by Brian Knight . I was delighted to hear about an improvement to the SQL Server maintenance plan that Read More... Posted 13 February 2005 17:08 by jamie.thomson | 1 Comments Filed under: SQL Server Integration Services, SSIS

• SSIS: Asynchronous and synchronous data flow components

  I recently asked Ovidiu Burlacu from the SSIS dev team to clarify the difference between a synchronous and an asynchronous data flow component in SQL Server Integration Services. He replied not just with that information but also some of the implications Read More... Posted 11 February 2005 22:21 by jamie.thomson | 10 Comments Filed under: SQL Server Integration Services, SSIS, Dataflow Task

• SSIS: Writing to a variable from a script task

  This is a very short post containing a useful code snippet for writing to a SQL Server Integration Services (SSIS) variable from within a script task. Imports Microsoft.SqlServer.Dts.Runtime Public Class ScriptMain Public Sub Main() Dim vars As Variables Read More... Posted 09 February 2005 08:45 by jamie.thomson | 16 Comments Filed under: SQL Server Integration Services, SSIS, Scripting

• SSIS: Accessing a recordset in a script task

  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 Read More... Posted 08 February 2005 23:13 by jamie.thomson | 15 Comments Filed under: SQL Server Integration Services, SSIS, Dataflow Task, Scripting, Foreach Loop

• SSIS: Script task Intellisense icons

  If you're like me and attempting to use the script task in SSIS having never used Visual Studio before then all the icons in Intellisense and the object browser will mean diddly squat to you. This link should help to alleviate the problem! I never realised Read More... Posted 08 February 2005 20:44 by jamie.thomson | 1 Comments Filed under: SQL Server Integration Services, SSIS, Scripting

• SSIS: Libraries of tasks and transformations

  If you've been reading this blog for a while you'll have realised that I think SQL Server Integration Services (SSIS) is a major major improvevement on the product that it is replacing (DTS2000) however I do think that Microsoft have missed a trick somewhere Read More... Posted 05 February 2005 12:50 by jamie.thomson | 13 Comments Filed under: SQL Server Integration Services, SSIS