How to separate invalid data from table

  • For the date column, use a data convert component. Redirect failures into a union all.

    Put a conditional split after the conversion and do a check for invalid values in the second column. divert them to a new ouput. Send that output to the same union all.

    From the union all, push those into a table.

    Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!

Viewing post 1 (of 2 total)

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