blogs.conchango.com

Browse by Tags

• best practice
• Checkpoints
• configurations
• connection manager
• Dataflow Task
• DTS
• Foreach Loop
• Microsoft
• ole db source adapter
• raw files
• Scripting
• SQL Server
• SQL Server Integration Services
• SSIS
• template
• Variables

• SSIS Nugget: Ensure your root folder is valid

  In the past I have advocated (and still do advocate) the use of a user variable in SSIS packages to store the path to a folder on the hard drive; I always use a variable called @[User::RootFolder] for this. Having this path available within a package Read More... Posted 19 May 2008 11:57 by jamie.thomson | 3 Comments Filed under: SQL Server, SSIS, Microsoft, Expressions, template

• SSIS: Dynamically set a checkpoint file location

  Someone recently asked me if it was possible to dynamically set the location of a checkpoint file. Happily the answer is yes and in actual fact its something that I do all the time so that my packages can all work in conjunction with my Common Folder Read More... Posted 15 November 2007 18:52 by jamie.thomson | 2 Comments Filed under: SQL Server Integration Services, SSIS, Expressions, Checkpoints

• SSIS: Dataflow expressions

  Did you know that it is possible to set expressions on components within the dataflow? Expressions on data-flow components was virtually the very last feature that was added to SSIS 2005 prior to RTM. All components CAN support expressions on their custom Read More... Posted 09 October 2007 05:12 by jamie.thomson | 7 Comments Filed under: SQL Server Integration Services, SSIS, Dataflow Task, Expressions

• SSIS Nugget: Construct a timestamp value

  Visitors to the SSIS forum often ask how to construct a date string in the form YYYYMMDDHHMISS (e.g. "20070207123456" for "7th February 2007, 12:34:56") using a SSIS expression. I always give the same answer so I thought I'd post Read More... Posted 07 February 2007 22:41 by jamie.thomson | 3 Comments Filed under: SQL Server Integration Services, SSIS, Microsoft, Expressions

• SSIS: Expressions on ForEach enumerators

  I've noticed a few people on the SSIS forum lately asking about expressions on the Foreach Loop. They are aware that its possible to set expressions on properties of the Foreach container but are flummoxed when it comes to setting expressions on the Read More... Posted 13 October 2006 22:35 by jamie.thomson | 14 Comments Filed under: SQL Server Integration Services, SSIS, Expressions, Foreach Loop

• SSIS Nugget: Dynamically set a logfile name

  Anyone who reads this blog regularly knows I am a big fan of using expressions to achieve results in SSIS. In this post I'm going to show a very simple example of using them. If you are building SSIS packages then you will be (or you should be) using Read More... Posted 05 October 2006 05:44 by jamie.thomson | 31 Comments Filed under: SQL Server Integration Services, SSIS, Expressions Attachment(s): DynamicLogfile.zip

• SSIS: But it used to work in DTS (1) - Modifing a Package in script

  I've said on numerous occasions, in slightly different ways, that making the move from DTS to SSIS is not a simply a matter of learning a new technology. Its a new way of thinking as well. I have come across many examples of people coming unstuck Read More... Posted 28 June 2006 13:24 by jamie.thomson | 5 Comments Filed under: SQL Server Integration Services, SSIS, DTS, Expressions

• SSIS Nugget: Setting expressions

  Whilst reading posts on the SSIS forum of late it has become evident that people are unaware of the power that expressions can provide within an SSIS package. This is understandable - alot of people are starting to use SSIS now but expressions aren't Read More... Posted 11 March 2006 09:24 by jamie.thomson | 27 Comments Filed under: SQL Server Integration Services, SSIS, raw files, Expressions, Foreach Loop

• 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 | 50 Comments Filed under: SQL Server Integration Services, SSIS, raw files, ole db source adapter, connection manager, Microsoft, Scripting, Expressions, best practice, configurations, Variables, Checkpoints, template

• 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 | 15 Comments Filed under: SQL Server Integration Services, SSIS, Expressions, best practice

• SSIS: Expression editor on Expression property of a variable!

  It is coming in SP1 apparently. Thank god - this was a glaring hole in v1. My workaround s to build my expressions on a property of a task and then paste them across. Not good!!! -Jamie Read More... Posted 25 October 2005 07:11 by jamie.thomson | 0 Comments Filed under: SQL Server Integration Services, SSIS, Expressions

• SSIS: Custom Logging Using Event Handlers

  SQL Server Integration Services (SSIS) contains some really useful logging procedures but as with most things in SSIS, it is extensible. There are 2 methods of extending the logging capability of SSIS: Build a custom log provider Use event handlers I Read More... Posted 11 June 2005 15:29 by jamie.thomson | 100 Comments Filed under: SQL Server Integration Services, SSIS, Scripting, Expressions

• SSIS: Configurations or command-line parameters?

  Dynamically changing a SQL Server Integration Services (SSIS) package at runtime is something many SSIS designers will find themselves doing. There are a number of methods of doing this and I've covered the main ones already: Property Expressions (look Read More... Posted 17 May 2005 16:24 by jamie.thomson | 5 Comments Filed under: SQL Server Integration Services, SSIS, Expressions, configurations

• SSIS: Evaluating variables as expressions

  I have aluded as to the use of SSIS property expressions quite a few times on this blog. Regular readers will know what I think of them by now - they're a great mechanism for dynamically modifying the behaviour of your SSIS package at runtime. In short, Read More... Posted 19 March 2005 16:39 by jamie.thomson | 62 Comments Filed under: SQL Server Integration Services, SSIS, Expressions, configurations

• SSIS: Dynamic modification of SSIS packages - Part II

  Yesterday I posted a blog entry that explained some of the options available for dynamically changing SQL Server Integration Services packages at runtime. Paul Shotts posted a comment stating that in DTS he often used the "Dynamic Properties Task" to Read More... Posted 01 March 2005 17:21 by jamie.thomson | 16 Comments Filed under: SQL Server Integration Services, SSIS, Expressions, configurations