Welcome to EMC Consulting Blogs

August 2006 - Posts

• SSIS: Import/Export wizard warning

  Just lately I have been making heavy use of the Import/Export wizard in SQL Server Management Studio and on the whole I'm very pleased with it. I have though come across one problem with it that caused me no end of trouble before I discovered what was Read More... Posted 29 August 2006 15:30 by jamie.thomson | 2 Comments Filed under: SQL Server 2005, SQL Server Integration Services, SSIS

• SQLCLR: Replacement for xp_getfiledetails

  I'm currently working on migrating a SQL Server 2000 system to SQL Server 2005 and one of the issues we have come across has been that the undocumented stored procedure xp_getfiledetails (which is being used in our SQL2000 solution) no longer exists. Read More... Posted 24 August 2006 10:31 by jamie.thomson | 5 Comments Filed under: SQL Server 2005 Attachment(s): Conchango.SqlServer.SqlClrToolkit.GetFileDetails.zip

• VSTS4DB: Agile development of data dude

  I read with interest on Gert Drapers' blog of how the development team of Visual Studio Team System for Database Professionals (aka Data Dude) are practicing Agile delivery methods . Gert is the development manager for this new product. Its great to see Read More... Posted 19 August 2006 09:22 by jamie.thomson | 0 Comments Filed under: Visual Studio Team System For Database Professionals, datadude, Team System

• SSIS: Date bug in SP1 fixed

  If you have been reading this blog for a while you will know about the issue where installing SP1 could break any packages that have dates stored within them. Well good news, its been fixed for the next release. All the details are here at Microsoft Connect Read More... Posted 16 August 2006 15:18 by jamie.thomson | 0 Comments Filed under: SQL Server Integration Services, SSIS

• SSIS: Is SSIS a professional data integration tool?

  Steve Sauer (I'm guessing that is his name) is writing a diploma thesis in which he is comparing various data integration suites including BO Data Integrator, Informatica and various others. And SSIS of course (otherwise why would I be writing this post). Read More... Posted 15 August 2006 09:10 by jamie.thomson | 3 Comments Filed under: SQL Server Integration Services, SSIS

• SSIS: Destination Adapter Comparison

  I recently had cause to look into the various ways that I could load data from the SSIS pipeline into SQL Server. There are three destination adapters for doing this: OLE DB Destination OLE DB Destinaton with FastLoad SQL Server Destination [OK, the first Read More... Posted 14 August 2006 22:21 by jamie.thomson | 62 Comments Filed under: SQL Server Integration Services, SSIS, Dataflow Task Attachment(s): DestinationInsertions.zip

• SSIS: Loading a Kimball data warehouse using SSIS

  I have just been watching Joy Mundy's webcast " Loading a Kimball method data warehouse using SQL Server Integration Services ". I highly recommend it - Joy has done great job in outlining the basic skeleton for loading a data warehouse Read More... Posted 14 August 2006 21:22 by jamie.thomson | 6 Comments Filed under: SQL Server Integration Services, SSIS, kimball, configurations

• SSIS: OnVariableValueChanged event

  One of the least-known features in SSIS, certainly one of the least-used, is the OnVariableValueChanged eventhandler. I had never actually used it myself so I thought I'd waste away my morning commute by looking into it a little. Firstly, what IS the Read More... Posted 08 August 2006 12:34 by jamie.thomson | 2 Comments Filed under: SQL Server Integration Services, SSIS Attachment(s): OnVariableValueChangedDemo.zip

• SSIS: But it used to work in DTS (9) - Add a timestamp to the data in the data pump

  Here is the next in my series of posts explaining how common tasks in DTS can now be implemented in SSIS. Add a timestamp to the data in the data pump This is a common requirement for auditing purposes. people need to know when a row was processed. There Read More... Posted 07 August 2006 08:26 by jamie.thomson | 1 Comments Filed under: SQL Server Integration Services, SSIS, DTS

• SSIS: Improve Debugging in Katmai

  The next version of SQL Server (codenamed katmai) is currently in the planning stages so if you want new functionality to be included, now is the time to get your requests into Microsoft via Microsoft Connect . There are many areas that can be improved Read More... Posted 04 August 2006 15:23 by jamie.thomson | 1 Comments Filed under: SQL Server Integration Services, SSIS

• SSIS Nugget: NEWID() function in the SSIS Pipeline

  Very short blog post this one. A guy on the SSIS Forum recently wanted to add a new GUID into the pipeline and was pertubed that there was no equivalent of T-SQL's NEWID() function in the SSIS Expression Language with which to do it. I agree that there Read More... Posted 04 August 2006 09:41 by jamie.thomson | 2 Comments Filed under: SQL Server Integration Services, SQL Server, SSIS, Nugget

• SSIS Nugget: Aggregating data

  I was recently contacted by Octoni Simbolon who asked me: "[In a data flow] can we assign each row to a variable before load to destination oledb, so we can manipulate each row and field ?" Strictly speaking I suppose you can do this by assigning to a Read More... Posted 04 August 2006 09:10 by jamie.thomson | 2 Comments Filed under: SQL Server Integration Services, SSIS, Dataflow Task, Nugget Attachment(s): 20060804CalculateStartAndEnd.zip