Set Text qualifier to
double quote.
Reference:
http://social.msdn.microsoft.com/Forums/sqlserver/en-US/923b39ef-bb91-430a-8791-f538870cffdd/how-to-remove-quotations-from-import-flat-file?forum=sqlintegrationservicesprotected void Application_Start() { DataAnnotationsModelValidatorProvider.RegisterAdapter( typeof(i18n.DataAnnotations.RequiredAttribute), typeof(RequiredAttributeAdapter)); } namespace i18n.DataAnnotations { public class RequiredAttribute : System.ComponentModel.DataAnnotations.RequiredAttribute, ILocalizing { private readonly I18NSession _session; public RequiredAttribute() { _session = new I18NSession(); } public virtual IHtmlString _(string text) { return new HtmlString(_session.GetText(HttpContext.Current, text)); } public virtual string TT(string text) { return _session.GetText(HttpContext.Current, text); } public override string FormatErrorMessage(string name) { var formatted = base.FormatErrorMessage(name); return _(formatted).ToHtmlString(); } } }
return System.Text.RegularExpressions.Regex.IsMatch(email, @"^([\w-\.]+)@((\[[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}\.)|(([\w-]+\.)+))([a-zA-Z]{2,4}|[0-9]{1,3})(\]?)$");