ssis flat file source trim blank spaces

Question

Is there any way i can trim the blank spaces when I read data from CSV file?

Thanks.

Answer 1

Use a derived column component after the CSV input, in the editor you should see columns in top-left so drag the email column into the editor and replace any spaces with empty strings. You should also set the derived column to replace the email column (Or you could add it as a new column, if you need that).

Answer 2

The SendMail task requires ';' between email ids. If you are building one large string to send your email to, consider using a script component to remove spaces and append a';' between each one.