Welcome to EMC Consulting Blogs

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