Hi all, I have one requirement. My source is .txt (tab delimited format) and destination is DB2. TRANSACTIONTYPECODE PREM PREM Intax COMM PREM I need to update new column through dervied column tha one is ... Transaction type (Description that matches the Gensfile transaction type code) PREM = Base Premium PREM Intax = GST COMM PREM = Commission client want this one. vasu

Are you asking about creating the proper SSIS Expression? Then make the <Add as new column> set in Derived Column Transformation and then put this expression in: (Col1 == "PREM") ? "Base Premium" : (Col1 == "PREM Intax") ? "GST" : (Col1 == "COMM PREM") ? "Commission client want this one":"" Arthur My Blog Hi all, this is not given the results any another thing is there i have update for PREM=Base Premium through derived column. Vasu vasu

Hi Vasu, not sure I got what you said 100%, Can you use http://expressioneditor.codeplex.com/ and craft the proper expression?Arthur My Blog

Hi, I have tell simple. we have one column that data is Base. Client needs to same data create a new column update this word =" base prem". that is my requirement... Note:In my VDI download permissons is not there. Vasuvasu

How the client is going to create a new column? Where? Is the client using a GUI app?Arthur My Blog

I need to load into the DB2 database to separate column. vasuvasu

So your source is a text file and the destination is DB2, then you have the SSIS Expession adding the new column that you map to the destination. What piece of the puzzle is missing here, I do not still get that.Arthur My Blog

Hi , Expression is working fine ,But output is given empty. Iam using this one. ([Data Conversion].[Column 9] == "PREM") ? "Base Premium" : ([Data Conversion].[Column 9] == "PREM Intax") ? "GST" : ([Data Conversion].[Column 9] == "COMM PREM") ? "Commission " : "" Vasuvasu

I guess none of the conditions materialized therefore the last "" fires up. make sure you attest to the right data.Arthur My Blog

Hi, Sorry for the keeping meassages ,But your expression is working fine as for my anylasis source columns is getting some spaces("PREM.........") that's why result is null is displayed.Thing is that how to remove thease spaces in Your expression Ex: ([DataConversion].[Column 9] ==("PREM......... ") ? "Base Premium" <o:p></o:p> Vasu