Post reply

Conditional Split (dates)

  • August 1, 2016 at 7:43 am

    #400498

    Hi,

    I've searched the net and can't seem to find the exact answer I am after and I am still relatively new to SSIS.

    I have a file that is failing import due to four rows (out of 197,000!) containing bad dates. I decided to add a conditional split to move those four records to a separate table from my main data so that I can get those errors corrected.

    The errors are things like '200-03-12' instead of '2008-03-12' although not all errors are that format.

    So I was thinking, is there a way to say, if the date is not in this format (yyyy-mm-dd) then move to Table1 else put everything else in Table2? Or is there a better way entirely? I do want to end up with 2 tables though, one for my bad data and one for the good data.

    Thanks,

    Danny.

  • August 1, 2016 at 7:54 am

    #1892951

    Danny

    You'd probably be better off using an error output in your data flow. You can start here.

    John

  • August 2, 2016 at 2:54 am

    #1893155

    Hi,

    Yeah - you're probably right, that looks like a better way forward.

    Cheers.

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply