Error output in OLE DB Destination. How to redirect a row?
Hi, when I'm trying to redirect a row I'm having the following error: Error4Validation error. Data Flow Task: OLE DB Destination [535]: The error row disposition on "input "OLE DB Destination Input" (548)" cannot be set to redirect the row when the fast load option is turned on, and the maximum insert commit size is set to zero.PCKG_MPP.dtsx Can somebody help me?
November 14th, 2007 12:11am

Don't use fast load if you really want to redirect rows.If you must use fast load, you have to set the "Maximum Insert Commit Size" parameter to something other than zero. In which case, if you set MICS to 100, if a row fails, all 100 rows in that batch would get redirected. If you don't use fast load, then individual rows will get redirected. Note, that setting MICS to 1 in the fast load option would be the same as not using fast load.
Free Windows Admin Tool Kit Click here and download it now
November 14th, 2007 12:46am

I want to capture error rows in a text file. So I followed a workaround of using two OLE DB Dest tasks. First with fast load and other with normal load. When I set MICS to 100 in first task, I do not get any redirected rows. I've 500 records in a source file and 2 error rows (due to constraints) then 500-2 rows are loaded in the first OLE DB task but I do not get any batch of 100 reject rows which I can capture. Am I missing any setting here? I applied data viewer in the error branch of first OLE DB task but it shows no rows.Thanks
January 4th, 2008 5:42am

It sounds like nothing is actually erroring. Are you getting an error in the package execution, or are all the rows written to the destination?
Free Windows Admin Tool Kit Click here and download it now
January 4th, 2008 5:56am

The package executes without any error. But not all rows are written in the target table.The mesg I get[DTS.Pipeline] Information: "component "OLE DB Destination" (11630)" wrote 44490 rows. but only 43710 rows are loaded in the target table.To simplify things I have only one OLE DB Destination task (Fast Load, MICS 5000) and error redirected to a flat file destination. On package execution the error flat file is empty whereas it should have records in multiple of 5000.When I have OLE DB Destination task (Normal Load, MICS 0) then the error redirection shows 780 records in the error file.Still not getting what I'm missing and where I'm going wrong.Thanks
January 4th, 2008 2:54pm

You can adapt you error output. This is a tab into you OLE DB Source Data Flow. There you have to adjust the 'error' row from ' fail component' into redirect row. Then everything should be loaded in your destination table.
Free Windows Admin Tool Kit Click here and download it now
January 4th, 2008 5:52pm

I can get error output only after I've redirected the errors. This I've already done. My query is still open.Thanks
January 4th, 2008 8:54pm

Hi, Did you find any solution. I am also facing same problem. It is not iserting rows in db.
Free Windows Admin Tool Kit Click here and download it now
October 20th, 2010 8:45pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics