IME?

"Derived column transformation editor"

drag and drop a column into the bottom pane

right click on the 'expression' column and it has a menu item called "open IME"

but nothing happens when I do it.

Is it an expression editor?

Strategic thinking:

Microsoft BI

Reporting Services Expression language: VB.net

Integration Services Expression language: "similar to the syntax that the C and C# languages use"

great!

IME - Microsoft Global Input Method Editors (IMEs) - http://www.microsoft.com/windows/ie/ie6/downloads/recommended/ime/default.mspx

It is nothing to do with SSIS, it is just an option that Windows can provide for text boxes. There is no expression editor available for derived columns, just that free entry text box.

As for the new SSIS expression syntax, yes it is a bit annoying it is yet another syntax, but the benefit is that it is very fast and baked into SSIS. Anything else would not be as fast, and in ETL that counts.

sql