Set DTSX package to overwrite instead of Append

I have a SQL DTSx package that exports to a flat file.  It is appending rather that overwriting.  How can I set it up to overwrite?
Who is Participating?
Raja Jegan RConnect With a Mentor SQL Server DBA & ArchitectCommented:
In the connection manager, edit the Flat file destination. Check "Overwrite data in the file" to overwrite the file every time instead of appending.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.