I'm sure this is the simplest question but I can't figure it out, even with Google's help.
I am trying to stumble through some C# code in an SSIS script task and I am frustrated that I can't figure out how to do the easiest things. I eventually want to find data in a column,and then use another list as a lookup to replace that value with
another where the existing value matches a value in the lookup list. So, the data in my (multiple choice) column might be "apples; bananas" and in another list I have a row that contains two columns, the first holding the value "Apples"
and the second containing "Red Delicious" and my original column should read: "Red Delicious; bananas."
But, alas, I can't even figure out how to see the data that is in a column.
Here is my code:
Microsoft SQL Server Integration Services Script Task<br/>
Write scripts using Microsoft Visual C# 2008.<br/>
The ScriptMain is the entry point class of the script.<br/>
View Complete Post