how to eliminate invalid characters in text file while loading to sqlserve table using ssis? -

i have text file in records contains invalid characteres #,&,* in between words,now have remove characters , load th original word table, example: sam#som-->samsom su&*se-->suse

you accomplish want using script transformation , regular expressions.

here blog post on topic: pattern matching in ssis using regular expressions , script component