I want to move the data from SQL tables to flat files.
a, I want to move the correct data into one flat file and error data into another flat file.
b, I want to log the error details into another flat file. The flat file contains,error occured in the particular row,error occured due to contraint or due to invalid data type.
c, is it possible to do it through design mode without using any script?
Please guide me how can i proceed this.