Business Intelligence Blogs

View blogs by industry experts on topics such as SSAS, SSIS, SSRS, Power BI, Performance Tuning, Azure, Big Data and much more! You can also sign up to post your own business intelligence blog.

Keep in Mind: SSIS Replace Function is Case sEnsitive

  • 9 February 2012
  • Author: kylewalker
  • Number of views: 6781
  • 0 Comments

After a brief hiatus, I'm getting back into the swing of things with my blog.  To kick things off I'm going to share a helpful little tip about the SSIS replace function that, for some reason, wasn't specifically mentioned in the function's MSDN page.  If you find yourself needing the use the replace function in a Derived Column transformation within a Data Flow task, or in any SSIS expression for that matter, keep in mind that the function is case sensitive

 

SSIS Replace Function

 

Expression 1

 

APples

 

Expression 2

 

Oranges

Print
Tags:
Rate this article:
No rating

kylewalkerkylewalker

Other posts by kylewalker

Please login or register to post comments.