February 19, 2016 at 9:19 am
Hello,
I don't know anything other than very basic SSIS, but have a question / looking for advice on cleansing data particularly email addresses.
I run SQL SERVER 2014 BI edition and my company is starting to get into email blast business for marketing. Something fairly new to us and of course our clients do not use any type of form control so emails are missing .com and such. I have no experience with this type of thing so curious if any of you are using SSIS or more than SSIS?
Thank you and appreciate any feedback / suggestions.
February 19, 2016 at 9:29 am
butcherking13 (2/19/2016)
Hello,I don't know anything other than very basic SSIS, but have a question / looking for advice on cleansing data particularly email addresses.
I run SQL SERVER 2014 BI edition and my company is starting to get into email blast business for marketing. Something fairly new to us and of course our clients do not use any type of form control so emails are missing .com and such. I have no experience with this type of thing so curious if any of you are using SSIS or more than SSIS?
Thank you and appreciate any feedback / suggestions.
E-mail cleansing is essentially a string-processing exercise for which a CLR function may be a strong candidate.
Adding .com by default is not a great idea, IMO, because there are so many other possible suffixes. You could easily end up spamming the wrong users.
Here is a link which may also be of interest.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
February 19, 2016 at 11:16 am
Perfect and thank you!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply