i have a sql query...now im building my SSIS package using my query. so here is my question. Is there any data transformation task avaialble for building the case statement. dont want to write it as a sql task, but want to use any of these components to build my expression.
I saw this 'Derived Column' transformation task. but i really dont know how to built my expression. here is my case statement.
(case m_field7 when null then 'Yes' else 'No' end) as NonPrime
i would really appreciate if anyone could telll me what transformation to use and how to write a expression..