Welcome to EMC Consulting Blogs

January 2006 - Posts

• SSIS: Do you need to deploy raw files?

  Short one this. HarshB asked here: http://blogs.conchango.com/jamiethomson/archive/2006/01/04/2540.aspx#2670 if you need to deploy raw files along with your packages in order to use them. Happily the answer is no - if you set DelayValidation=TRUE on the Read More... Posted 23 January 2006 20:01 by jamie.thomson | 6 Comments Filed under: SQL Server Integration Services, SSIS, raw files, Dataflow Task

• SSIS: Put build numbers into your logging process

  A little tip here for any of you building SSIS packages. Some of you may know that I'm a big advocate of creating your own customised logging architecture through the use of eventhandlers as I have detailed here: http://blogs.conchango.com/jamiethomson/archive/2005/06/11/1593.aspx Read More... Posted 20 January 2006 13:19 by jamie.thomson | 2 Comments Filed under: SQL Server Integration Services, SSIS

• SSIS: In response to Daniel Read

  Update: Daniel has posted a detailed comment to this below! Those of you who read Daniel Read's blog will have read (3 different uses of the character sequence r-e-a-d in the space of 7 words - amazing) his excellent post today regarding eventhandlers Read More... Posted 19 January 2006 23:06 by jamie.thomson | 6 Comments Filed under: SQL Server Integration Services, SSIS

• SSIS: Workaround to the System::ContainerStartTime anomoly - derive the execution duration of a container PART 2

  2 days ago I posted a description (here: http://blogs.conchango.com/jamiethomson/archive/2006/01/16/2620.aspx ) of how one could go about capturing the execution duration of each container in your container hierarchy . Since then I've come to realise Read More... Posted 18 January 2006 20:26 by jamie.thomson | 3 Comments Filed under: SQL Server Integration Services, SSIS

• SSIS: Be wary of using SourceSafe

  On my current project we're making extensive use of SourceSafe to store our packages. We're using it directly from within BIDS and on the surface it works very nicely but we have had the odd problem here and there. The main one being that we get a periodic Read More... Posted 17 January 2006 08:48 by jamie.thomson | 4 Comments Filed under: SQL Server Integration Services, SSIS

• SSIS: Workaround to the System::ContainerStartTime anomoly - derive the execution duration of a container

  UPDATE: There are a couple of small issues with the code below that you should read about here: http://blogs.conchango.com/jamiethomson/archive/2006/01/18/2654.aspx Earlier today I wrote a short blog post explaining a problem with the System::ContainerStartTime Read More... Posted 16 January 2006 23:35 by jamie.thomson | 3 Comments Filed under: SQL Server Integration Services, SSIS

• SSIS: Using System::ContainerStartTime in an eventhandler

  Some time ago when SSIS was still in the beta stage I started to build my own custom logging procedures using event handlers (I have described this in some detail here: http://blogs.conchango.com/jamiethomson/archive/2005/06/11/1593.aspx ). I was able Read More... Posted 16 January 2006 21:07 by jamie.thomson | 5 Comments Filed under: SQL Server Integration Services, SSIS

• Source control in SSMS

  SQL Server Management Studio (SSMS) is the replacement for Enterprise Manager and Query Analyser in SQL Server 2005. It is hosted inside the Visual Studio shell which means that you can use VS's built-in support for source control systems. On previous Read More... Posted 08 January 2006 14:24 by jamie.thomson | 2 Comments Filed under: SQL Server 2005

• SSIS: Consuming Web Services in SSIS

  As many of you will already know, SSIS has a a Web Service task that enables you to make calls to a Web Service from within your package. Kathi Kellenberger has a good article in the November/December issue of SQL Server Standard that shows how to use Read More... Posted 08 January 2006 14:06 by jamie.thomson | 8 Comments Filed under: SQL Server Integration Services, SSIS

• SSIS: Common folder structure

  For reasons that I'll save until another post , I always deploy my packages as files rather than to SQL Server. In doing this I have derived a folder structure that I use in order to keep all my deployed packages and other files in the same place: Read More... Posted 05 January 2006 15:19 by jamie.thomson | 37 Comments Filed under: SQL Server Integration Services, SSIS, raw files, best practice, configurations, Checkpoints, template, indirect configurations Attachment(s): PackageToUseCommonFolderStructure.zip

• SSIS: Suggested Best Practices and naming conventions

  I thought it would be worth publishing a list of guidelines that I see as SSIS development best practices. These are my own opinions and are based upon my experience of using SSIS over the past 18 months. I am not saying you should take them as gospel Read More... Posted 05 January 2006 12:13 by jamie.thomson | 58 Comments Filed under: SQL Server Integration Services, SSIS, raw files, ole db source adapter, connection manager, Microsoft, Dataflow Task, Scripting, Expressions, best practice, configurations, Variables, Checkpoints, template

• SSIS: Recordsets instead of raw files

  Many moons ago on 8th February 2005 I posted a blog entry explaining how one could navigate over a recordset that is stored in an Object variable, created there by a Recordset destination. That blog entry is here: http://blogs.conchango.com/jamiethomson/archive/2005/02/08/960.aspx Read More... Posted 04 January 2006 08:48 by jamie.thomson | 53 Comments Filed under: SQL Server Integration Services, SSIS, raw files, Dataflow Task

• SSIS: Web Services Task becomes useful in SP1

  Anyone that has used the Web Services Task in SSIS will know that it isn't particularly useful because you can't change the parameters that are passed to it. Kirk Haselden has said that this is going to change in SP1 . According to him the Web Service Read More... Posted 03 January 2006 19:40 by jamie.thomson | 9 Comments Filed under: SQL Server Integration Services, SSIS

• SSIS: Using checkpoint files

  There's a few other things to be aware about when using checkpoint files that BOL does not tell you. Some of these may be obvious but its worth stating them anyway.: An OnPreExecute event on the package will not execute if the package is restarted using Read More... Posted 03 January 2006 15:19 by jamie.thomson | 3 Comments Filed under: SQL Server Integration Services, SSIS, Checkpoints