Notepad++ a free and useful tool

Notepad++ is a free source code editor and Notepad replacement that supports several languages. Running in the MS Windows environment, its use is governed by GPL License.

Almost every day I use Notepad++ for text file editing and from time to time to look at source files like Javascript and CSS. It supports syntax highlighting for various languages, which I find very useful. Notepad++ supports various plugins and does also have a column editing mode. To enable column editing mode just hold the "Alt" key and select the text with your left mouse button.

Notepad++ can be found here.

Some useful features of Notepad++:

• Syntax Highlighting and Syntax Folding
• Find and replace over multiple documents
• File comparison
• Zoom in and zoom out
• Multi-Language environment supported
• Drag-and-drop

SSIS Derived Column IF(IIF)

I use this post as a short reminder for myself, because the Derived Column Transformation Editor in SSIS simply does not spell out how to accomplish this.

The following syntax is used in the Derived Column control to place an IF(IIF) statement :
(Boolean Expression ? True Part : False Part)

So, if I were checking against a Trade Type code column (trade_type_cd) to determine whether this column IS NULL or IS NOT NULL, I could simply write up something like this:
ISNULL(trade_type_cd) ? "<Unknown>" : trade_type_cd