Welcome to EMC Consulting Blogs

December 2005 - Posts

• SSIS: New Wrox book coming out

  There is a new SSIS book from Wrox coming out which you can pre-order now from Amazon: http://www.amazon.com/exec/obidos/search-handle-url/index=books&field-author-exact=Allan%20%20Mitchell&rank=-relevance%2C%2Bavailability%2C-daterank/002-0421744-4604000 Read More... Posted 30 December 2005 21:05 by jamie.thomson | 1 Comments Filed under: SQL Server Integration Services, SSIS

• SSIS: Errors, warnings and information

  A reference page has appeared on MSDN contianing all of the SSIS error, warning and innformation messages and associated error numbers. It is at: http://msdn2.microsoft.com/en-us/library/ms345164.aspx . Doubtless anyone interested in this has already Read More... Posted 29 December 2005 13:32 by jamie.thomson | 2 Comments Filed under: SQL Server Integration Services, SSIS

• Flashearth

  I have finished work for 2005 so for a short time I can spend my weekends relaxing rather than having my 7am Monday morning flight to Aberdeen preying on my mind. To that end I've been exploring something that has been interesting me for a while - Google Read More... Posted 18 December 2005 17:00 by jamie.thomson | 0 Comments Filed under: Inane Waffle

• SSRS: Flattened rowsets versus cellsets

  Its not often that I link to other blog posts but I saw one this evening on Brian Welcker's (have I spelt that right - I normally get it wrong?) blog that I thought was worthy of a mention. Here's the link to it: http://blogs.msdn.com/bwelcker/archive/2005/12/15/504305.aspx Read More... Posted 15 December 2005 23:26 by jamie.thomson | 1 Comments Filed under: SQL Server Integration Services, SSIS

• SSIS: Using dynamic SQL in an OLE DB Source component

  I reckon that one of the most commonly used components in SSIS is the OLE DB Source component . This is the one that you use to pick up data from an OLE DB compliant data source (e.g. a database) in order to use that data in your pipeline. This is done Read More... Posted 09 December 2005 09:49 by jamie.thomson | 58 Comments Filed under: SQL Server Integration Services, SSIS, ole db source adapter, best practice

• SSIS: Using variables to store expressions

  I have extolled the virtues of the expression language in SSIS more times than I care to remember and quite frankly regular readers of this blog must be fed up of me banging on about them. Well I make no excuse for it - property expressions dramatically Read More... Posted 05 December 2005 09:20 by jamie.thomson | 20 Comments Filed under: SQL Server Integration Services, SSIS, Expressions, best practice

• SSIS Nugget: Splitting a file into multiple files

  The following question was posed on the SSIS forum recently: I have a table with 25 Million records. I want to transfer the records from the table to flat files. One flat file can contain only 1 Million record. So I need to generate 25 flat files with Read More... Posted 04 December 2005 21:51 by jamie.thomson | 16 Comments Filed under: SQL Server Integration Services, SSIS, raw files, Dataflow Task

• Social: i-pod survey

  Hi, We're not supposed to put personal stuff on our blogs but for once I'm taking liberties. My girlfriend's baby sister is currently writing a dissertation on i-pods, associated paraphernalia and the advent of "cool-dom". To support this she's running Read More... Posted 02 December 2005 17:22 by jamie.thomson | 0 Comments Filed under: Inane Waffle

• SSIS: Appending to a raw file

  Just lately I've been breaking the cardinal rule of blogging: "Thou shalt always blog". Well the reason is simply that I've been heads-down on my current project and: a) Haven't had anything to blog about and b) Haven't got time to anyway! Well b) is Read More... Posted 01 December 2005 12:07 by jamie.thomson | 5 Comments Filed under: SQL Server Integration Services, SSIS, raw files, Dataflow Task