I need to get value from one table and if it is (for example) string - TodayDate, I need to change it to "Today Date" with a space in it and use it later in my Data Flow.
So I would need something similar to
If value = "TodayDate" Then
value - "Today Date"
Else
.....
How do I do that?
Thanks.
Check on the Derived Column transform in SSIS dataflow task.
|||To add to Wenyang's answer...you will need to use the Conditonal Operator within the Derived Column transform.
? : (Conditional) (SSIS)
(http://msdn2.microsoft.com/en-us/library/ms141680.aspx)
Wenyang, I don't thinkyour answer is complete. Do you really think it warrants being marked as an answer? Hope you don't mind me asking.
Regards
Jamie
|||How do I create expresiion?
Column Name - MonitorType
MonitorType ? "SA" : @.MyVariable
This shows error.
I want to see if the MonitorType field returns "SA" and if yes - use the variable I have.
If it returns for example "BA" use another variable.
|||
Vita wrote:
How do I create expresiion?
Column Name - MonitorType
MonitorType ? "SA" : @.MyVariable
This shows error.
I want to see if the MonitorType field returns "SA" and if yes - use the variable I have.
If it returns for example "BA" use another variable.
MonitorType == "SA" ? @.[MyVariable] : @.[SomeOtherVariable]
-Jamie
|||Thanks.
|||Please don't forget to mark posts as answered.|||What if I have more than 2 variables.
If "SA" - var 1,
If BA" - var 2
If "DA" - var 3
If "DS" - var 4
Can I do Else If in the same expression?
|||I believe you can continue to add additional tests in the Derived Column task.
Rob
|||
Vita wrote:
What if I have more than 2 variables.
If "SA" - var 1,
If BA" - var 2
If "DA" - var 3
If "DS" - var 4
Can I do Else If in the same expression?
Yes. You need to nest the Conditonal Operator.
MonitorType == "SA" ? @.var1 : (MonitorType == "BA" ? @.var2 : (MonitorType == "DA" ? @.var3 : (MonitorType == "DS" ? @.var4 : @.SomeDefaultVariable)))
-Jamie
please don't forget to mark as answered.
|||Thanks again. I appreciate it.
No comments:
Post a Comment