I need to be able to remove the special characters in the data flow before inserting the record. I'm just trying to determine the most effective way to do this. I can do a replace on the column using a derived data flow transformation, but it seems as though there is a better way to do this...It can be done in a script as well, but my scripting skills are lacking a bit. Basically it comes down to Derived data flow or script task from what I'm reading, but which is the best method to achieve the results I'm wanting?
I ended up doing a REPLACE on the characters I needed...the script task would only work by storing an array of characters to remove. Ultimately, a reg. expression will work and is just as efficient as a script task (though the code is not as pretty).