HI, I am trying to search for information regarding SSIS 2005 data flow task. I have entered into the search box several different values for this search and none of the results are coming close to the search words. Is there a problem with the search component? I am trying to find out when there is an error how to redirect a whole row of flat file input to another flat file. Thanks! Paws27284
If the component that fails has an error Output property, like the Lookup transformation, then you can double click on it and change the eror value from Fail Component to Redirect Row. Then you can connect the red data flow line to the other flat file. But if there is not an option, like for the flat file destination, then you would need to use a conditional split earlier in the data flow to check for errors.