Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Sonu619
Posting Yak Master
202 Posts |
 Posted - 2011-02-15 : 21:32:50
|
| Here is the sample dataID,ADDRESS1,ADDRESS2,ADDRESS31,BLANK,1458 HIGH AVE,LOS ANGLES CA 927782,BLANK,ORANGE COUNTY CA 92334, BLANK3,IRVINE CA 98776,BLANK,BLANKHere is the situation, I have 3 different column CITY,STATE,ZIP in target and i want to parse address. First I want to see Address3 if it blank, try Address2 if it is blank, try Address3. I know we can use Derived column transformation to fix this problem in SSIS. Please help me out with expression in SSIS. Thanks . |
|
|
|
|
|
|
|
Derived Column Help