How to rewrite the CASE statement into an SSIS expression?

sql ssis case-when
pentjosh picture pentjosh · Feb 15, 2013 · Viewed 16.3k times · Source

I have the following SQL query that I need to use in a Derived Column Transformation available in SSIS.

CASE WHEN A IN (1,2,3) THEN "ABC"
ELSE "NA" END

How do I rewrite this statement into an SSIS expression?

Answer

Justin picture Justin · Feb 15, 2013

Derived Column Expression Code:

A == 1 || A == 2 || A == 3 ? "ABC" : "NA"

It will chek if A is equal to 1 or 2 or 3 and if yes, will be "ABC" else "NA".

Related questions

How to pass variable as a parameter in Execute SQL Task SSIS?

I have ssis package in that I'm taking values from flat file and insert it into table. I have taken one Execute SQL Task in that creating one temptable CREATE TABLE [tempdb].dbo.##temptable ( date datetime, companyname nvarchar(50), price decimal(10,0), …

Read More
Text was truncated or one or more characters had no match in the target code page including the primary key in an unpivot

I'm trying to import a flat file into an oledb target sql server database. here's the field that's giving me trouble: here are the properties of that flat file connection, specifically the field: here's the error message: [Source - 18942979103_txt [424]] …

Read More
Watching variables in SSIS during debug

I have a project in SSIS and I've added an Execute SQL Task which sends its result out to a variable. I wanted to confirm the value because I was worried that it would try to write it out as …

Read More