Hi, Please help me out that me source is missing some rows after solving that in source how to load that rows in ssis packages Thanks ram's

Hi Ram, How do you detect the missing rows? Where the missing rows need to go to?Arthur My Blog

Hi, After transfer the 50000 row's from source to destination a bad row is redirected to error destination then how to load that redirected rows in destination regards Ram's

Hi , redirected into a errorque table in sql server and for the next time package run first load that rows into desitination Thanks Ram

Understood, I will point you out to a blog post describing this technique so you would learn: One approach is: http://agilebi.com/jwelch/2008/09/05/error-redirection-with-the-ole-db-destination/ and another http://www.rad.pasfu.com/index.php?/archives/23-How-to-handle-Failed-Rows-in-a-Data-Flow.htmlArthur My Blog

Please move this to SSIS forum. Right click on the Destination Component and choose Edit > Error Output > set error to Redirect Row. Create anothercomponent which will handle the redirected rows. Drag the error output from the Destination Component into the new component. http://www.jasonyousef.com/2011/11/error-rows-code-and-description-in-ssis.html

Hi arthurz, im redirect the rows but how load tha rows in to destination after clean Thanks Rams

The fact that the rows were re-directed from the destination load implies that there is an error in loading. Hence if you try to load it again to the destination table it will error out again. You can log the errored rows in a different table alongwith the error code and description as mentioned by irusul, fix the error and run an import from this error table again to your destination.~V

if you want to catch bad data rows you can use configure error output in component like this: http://www.rad.pasfu.com/index.php?/archives/23-How-to-handle-Failed-Rows-in-a-Data-Flow.html But if you catched the bad data row already, then you need to find a work around on that and add appropriate data flow components instead of error destination component ( the destination that you are using already to log error records), for example if you found that you may have some non-integer characters in a numeric column value, then you can use derived column or script component to remove those characters and CLEANSE data. and then add them with a UNION transform to main and correct data stream and load them all into main destination .http://www.rad.pasfu.com

You could use another component to catch and change bad data so they get successfully imported into destination.

Hi Ram manthena, Just as irusul said, you can use another component to catch error rows, details step please refer to: Creating an error output from a script component: http://colinkirkby.blogspot.com/2007/01/ssis-creating-error-output-from-script.html Bundling Errors in the Data Flow: http://agilebi.com/jwelch/2008/02/19/bundling-errors-in-the-data-flow/ Thanks, Eileen