Post reply

Redirect doesn't work from datareader source error on date field

  • March 1, 2011 at 1:55 pm

    #247459

    I have a datareader source (teradata) that has junk in a date field. I redirect all columns on failure to sql server table. When I get the error the job stops and nothing is sent to the sql server table. What do I need to do to keep the job going and send the bad data to the Sql Server table? I have a similar problem with email redirect. I must be doing something wrong with consistency. I have the error limit set to 1 does the stop the job as soon as it occurs. My assumption is the error should be sent to the table and ignored.

  • March 1, 2011 at 2:53 pm

    #1293239

    Found the answer. Error occured while writing to the output not from the datareader source. Thought it would be considered as one action.

    Does not seem as though I can redirect the output table error. Is this correct ?

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

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