SSIS - Import text file Into SQL Server

Hi, I know how to import text file into sql server, I created SSIS package for this one.

Before I import I want to do small changes in text file, basically find and replace.

I would like to FIND "SM 4500 NO3F, 20th Ed." and REPLACE with "SM 4500 NO3F 20th Ed." how can i do that.

do I need to use script? please help me.

Thanks

You can do one of two things. You can do this with a script task and read in each line.

Or you can set up a data flow and read in the entire line as one column. Then use a derived column transform to do the find replace on the entire line. Write this data to a staging flat file and read that in your regular data flow.

I wrote an article that covers this issue.

http://www.bidn.com/articles/integration-services/112/handling-headers-in-flat-files-with-ssis