There is a parameter in DTS packages that allows you to overwrite the file you are saving. AppendIfFileExists. However, all the documentation is ambiguous as to how to set this. I am using SQL Server 2000. Can anyone help me?
satya, Yes I know this property exists, I just can't find out how to set this anywhere. There are no examples on how to set this or any other parameter that I can find. Have you ever donw this? Thanks for your help. Todd