Hey everyone. First let me say that I'm new to the forums and new to SSIS. I've been a .Net developer since the beginning but never used SSIS until now. With that said, here is my issue.
My Problem: I have a situation where I have data coming from a mainframe Db2 source and one of the fields is a state column. It can hold either the state code (NC) or the name of the state (North Carolina). Our target table
will only hold the 2-character state code. So I need to check the State column for each record and if the length is greater than 2 characters, I need to do a lookup and return the state code for the given state name.
I initially was going down the path of using a Conditinoal-Split task to split the records based on the state column being 2 characters or bigger, with a Fuzzy Lookup for the state name and then a Merge task to merge the two sets of records back together
before inserting into my target. However, I was in an SSIS training class this past week and ran this solution by my instructor and he thought that a Script Component would be better for this kind of transformation.
So I've been working on my second solution using a Script Component Transformation task and my input was the State column and my output was the transformed state code.&n
View Complete Post