Home Forums Data Warehousing Integration Services Flat File Source: prevent records from loading with a valid date but in the wrong format RE: Flat File Source: prevent records from loading with a valid date but in the wrong format

  • July 23, 2013 at 10:58 am

    #1635074

    If you're a fan of Regular Expressions, you could do a Regex match on it to reject anything other than

    NNNN-NN-NN

    where N is in the range [0-9].

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.