Post reply

SSIS, Append CSV File

  • March 27, 2009 at 7:38 am

    #130228

    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

  • March 27, 2009 at 8:11 am

    #967459

    In the Flat File Destination Editor, Uncheck the box 'Overwrite data in the file'

  • March 30, 2009 at 2:14 am

    #968170

    Thank You this works to an extent.

    It unfortunatlely it repeats the header, I have the on my connection first row contains header as i don't know where in the data flow will give errors.

    Please Assist

  • March 30, 2009 at 3:24 am

    #968185

    Hi,

    I got it going using flat file destination with overwrite set to false & connection with no headers.

    Thank You

    Regards

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply