Welcome to blogs.conchango.com

Browse by Tags

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

• Making the case for expressions instead of parameterised SQL (and vice versa) : SSIS Nugget

  [Although I colloquially refer to myself on this blog as “SSIS Junkie” it won’t have escaped the notice of regular readers that I haven’t been talking about SSIS much lately, in fact nothing of real substance in regard to SSIS has appeared here since Read More... Posted 08 December 2008 13:35 by jamie.thomson | 1 Comments Filed under: SQL Server Integration Services, SQL Server, SSIS, T-SQL, Expressions, Execute SQL Task, Nugget, sp_executesql

• SSIS: What does the 1252 in (DT_STR, X, 1252) mean?

  When casting to a non-unicode textual value (i.e. DT_STR) in SSIS you might often have seen something like the following: (DT_STR, 50, 1252) ( <expression> ) and wondered what on earth the 1252 was referring to. Well the SSIS documentation on MSDN Read More... Posted 08 November 2008 10:10 by jamie.thomson | 3 Comments Filed under: SQL Server Integration Services, SQL Server, SSIS, Expressions

• SSIS Nugget: Nesting variables to calculate values

  I was looking over a package today that a colleague had built and it contained the following code in a Script Task that was being used to return today’s day name: Public Sub Main() ' Dim sWeekday As String sWeekday = Now().DayOfWeek.ToString Dts.Variables( Read More... Posted 24 October 2008 10:44 by jamie.thomson | 8 Comments Filed under: SQL Server Integration Services, SQL Server, SSIS, Expressions, Variables, Nugget

• SSIS Nugget: Conditionally email a file containing error rows

  Someone emailed me today asking: I have an SSIS package that outputs data that can’t be inserted into destination tables into flat log files [JT: I presume he means that error rows are redirected to a flat file] What is the easiest way to then after processing Read More... Posted 11 July 2008 20:02 by jamie.thomson | 6 Comments Filed under: SQL Server Integration Services, SQL Server, SSIS, Dataflow Task, Expressions, Demo, Nugget

• 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, Nugget

• 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 | 3 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, Nugget

• 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 | 29 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 | 34 Comments Filed under: SQL Server Integration Services, SSIS, Expressions, Nugget 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 | 30 Comments Filed under: SQL Server Integration Services, SSIS, raw files, Expressions, Foreach Loop, Nugget

• 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 | 57 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: 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: 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