Welcome to EMC Consulting Blogs

Browse by Tags

• datadude
• Dataflow Task
• Nugget
• regex
• Scripting
• SQL
• SQL Server 2005
• SQL Server Integration Services
• SSIS
• Visual Studio Team System For Database Professionals

• T-SQL: Remove collation statements using Regular Expressions

  I use datadude quite alot and recently I imported lots of tables into my datadude project but forget to configure it to not import the collation (more on how to configure that some other time). Hence, I had a huge collection of tables with unwanted collation Read More... Posted 04 June 2007 22:47 by jamie.thomson | 0 Comments Filed under: Visual Studio Team System For Database Professionals, datadude, regular expressions

• SSIS Nugget: Extract last word from a sentance using regular expressions

  About a month ago I wrote this very simple blog post explaining how one might go about stripping off the last word from a sentance in the pipeline. My Conchango colleague James Saull thought that this would be ripe for a regular expression (and he's Read More... Posted 19 December 2006 08:45 by jamie.thomson | 1 Comments Filed under: SQL Server 2005, SQL Server Integration Services, SQL, SSIS, regex, regular expressions, Nugget Attachment(s): 20061219lastWordUsingRegex.zip

• SSIS Nugget: The script component and regular expressions

  Another quick nugget here to demonstrate Regular Expressions . For those that don't know, regular expressions are a nifty way of matching incoming textual values to a required format. Probably best that I don't try and explain it any more. Read on... Read More... Posted 04 July 2005 22:29 by jamie.thomson | 11 Comments Filed under: SQL Server Integration Services, SSIS, regex, regular expressions, Dataflow Task, Scripting, Nugget