SQL Server Performance

SSIS, Append CSV File

Discussion in 'SQL Server 2005 Integration Services' started by Ismailc, Mar 27, 2009.

  1. Ismailc New Member

    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
  2. MohammedU New Member

    I think there is an option like check box to overwrite the file so you need to uncheck it...
    You can use Excel which always appens not overwrites...
  3. Ismailc New Member

    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

  4. Ismailc New Member

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

    Thank You

Share This Page