DTS overwrite vs append

[Brit]

I have a text file with data that needs to replace all the data in my SQL 7 table. I have created a DTS package but when I run, the text file data is appended to the table. How do I clear the table and fill rather than append?

thanks for your help.

 

[vechalapu]

Hi,

Create a SQL task to truncate existing records in the table and run your load task to load the records in your text file.

I hope this helps.

 

[tlbroadbent]

You can add the truncate as a step in the existing package. Create the workflow from the truncdate to the append indicating the append step should only run when the truncate is succesfully executed. Terry L. Broadbent
Life would be easier if I had the source code. -Anonymous