CODEWITHSUNDEEP
sql-serverssis
user1804925
user1804925

Reputation: 159

Derived Column Transformation conditions error

enter image description here

I got the above error.

I am trying to accomplish below conditions.

a. If EpicLocationKey = RevenueLocationKey then output EpicLocationKey = EpicLocationKey
b. If RevenueLocationKey in (0,1) then output EpicLocationKey = EpicLocationKey
c. Else output EpicLocationKey = RevenueLocationkey

[EpicLocationKey] == [RevenueLocationKey] ? [EpicLocationKey] : [RevenueLocationKey] IN (0, -1) ? [EpicLocationKey] : [RevenueLocationKey]

I try to test out the first condition. It is showing the similar error messages enter image description here

Upvotes: 0

Views: 31

Answers (1)

Tab Alleman
Tab Alleman

Reputation: 31785

Names in SSIS are case-sensitive. It can't find EpicLocationkey probably because it's EpicLocationKey like you have it in the middle part of the expression.

Upvotes: 1

Related Questions