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})(\]?)$");