March 14, 2012 at 10:12 am
Hello I am new to Integration Services. I am trying to split a table into two tables. To do this I need to create a new key using the derived column so that later I can create a relationship between the two new tables. It seems that my derived column is not populating like I expect it would. Below is the expression I am using in the derived column transformation editor.
project_manager_lastname == "Anyname" ? 1 : 2
March 14, 2012 at 11:03 am
If your source data has a key, why not just use that?
Your expression
project_manager_lastname == "Anyname" ? 1 : 2
is a valid conditional expression that should return a 1 when project_manager_lastname = "Anyname" and return a 2 when it does not. It doesn't seem like this is a very good key for more than 2 rows.
March 14, 2012 at 3:10 pm
Thank you for your response. Yes I agree it is not a very good key. I would perfer to have an autonumber of some sort but I am just learning how to use this tool so I wanted to start with something very basic. I was not getting any results though in my table and it turns out I wasn't mapping correctly.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply