Post reply

Error Redirection

  • June 4, 2009 at 3:00 pm

    #205501

    Hello

    I am trying to redirect bad SSN numbers from a table. certain SSN numbers have some date values. So, I need remove the dates seperately from SSN field.

    I did a (DT_DATE)TRIM(SSN) in a derived column and configured the error output by redirecting the rows. So one path with a derived column having the dates and other one having the proper SSN no.s. When i Union All and put them in a final table, I am able to get only 3 error outputs from SSN column. for example, only the first three dates in SSN column are redirected but the ones later still remain in the SSN column. Is there any count i need to set in order to redirect all error rows.

    Please throw some light on this.

    Thanks

  • June 8, 2009 at 7:56 am

    #1006077

    if the data comes in using a consistent format such as 123-45-67890 2009-03-23 Then you could use a substring to split the date and ssn into separate columns using a derived column task.

  • June 9, 2009 at 3:08 pm

    #1007083

    I agree with Paul. Just look up the SUBSTRING function.

    ----------------------------------------------------

  • June 10, 2009 at 6:24 am

    #1007300

    Ive also handled this sort of situation by adding a script

    componenet and creating a new output to redirect the

    entire row for my error handling. Just a thought 🙂

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

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