Hi, I need help. I have an error csv file and it writes successfully after one data flow task. But when at another task how do I append the new rows to the existing file? It always overwrites, tried raw file destination & set to append but not luck. Please assist, Regards
I think there is an option like check box to overwrite the file so you need to uncheck it... OR You can use Excel which always appens not overwrites...
Thank You, this works to an extent. It unfortunatlely it repeats the header, I have on my connection first row contains header as i don't know where in the data flow will give errors. Please Assist
Hi, I got it going using flat file destination with overwrite set to false & connection with no headers. Thank You Regards