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: 9331

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




Expression 2



Rate this article:
No rating


Other posts by kylewalker

Please login or register to post comments.