Hey yall,
So I am starting to create a process where I will be loading some info from a file to SQL tables. The problem is the vendor sends us wrapped files. Currently our process consists of manually doing a find and replace where we find '~clm' and replace it a
blank. This is our way of unwrapping the file.
Does anyone know of a way to unwrap this within an ssis package?
Here is a preview of some data.

so when we do a find '~clm' that we have to type in to remove the carriage return at the end of each line.
Please let me know if you know of any ways to do this!
Thanks,
Lyndsey
Lyndsey Cupit