SSIS – Global replace for all columns using a script component

This saved me a bunch of time—thanks, Waheed!

Waheed Rous

Sometimes while in the data flow you need to apply the same function on all the columns in the data flow or all columns have a specific data type, for example:

  1. Remove all commas and new lines from text columns before exporting them to a CSV file.
  2. Replace text “Null” with Null value when loading data from an excel file that has nulls as text in it.
  3. Check for each column if has a null value and replace it with a default value based on the data type.
  4. Convert all strings to upper or lower case. etc…

The easiest way to do this is to add a script component then use the approach below, here i’m converting all strings to upper case.

few notes about the code above:

  • i’m skipping all columns with name ends with “_isnull” as these columns just to indicate if the original column has a null…

View original post 46 more words

Markdown Test

I just had a terrible thought: what if WordPress lets you post in Markdown but converts it immediately to HTML and doesn’t preserve the original Markdown source. That would be a terrible shame. I’ll find out in a minute…

Oh, good—it does preserve the Markdown source. What a relief!

Write (More) Effortlessly With Markdown

I’m so happy they finally added Markdown to!!! Now we need it (natively) in the self-hosted (.org) version…

The Blog

Markdown has arrived on! Some of you may respond with “Finally!” Others might be asking, “what’s that?” Markdown is a quick way to add formatted text without writing out any HTML.

Let’s take a closer look. Here is an example of how Markdown looks while editing a post:

Markdown Example in the Text Editor

This is how that same example looks in the Reddle theme after it’s converted to HTML:

Markdown Example shown in the Reddle theme

Writing with Markdown

Markdown lets you compose links, lists, and other styles using regular characters and punctuation marks. If you want a quick, easy way to write and edit rich text without having to take your hands off the keyboard or learn a lot of complicated codes and shortcuts, then Markdown might be right for you.

For example, to emphasize a word, you just wrap it with an asterisk on both ends, like this: *emphasized*. When your writing is published, it will instead look like this:

View original post 285 more words