Does anyone know of a way to truncate a DBF file in DTS (SQL 2K)? I
have a dbf file that needs to be emptied before I can put info into
it.

set up a connection to the dbf file. then use an execute sql task to
delete the records.

Regards

Partha Mandayam
Software Consultant
Home page: http://partha.tripod.com


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Partha Mandayam <mcp111 (AT) hotmail (DOT) com> wrote

I tried that but the records are not being deleted, I'm not getting a
task error. Any other thoughts?

I tried it and it works fine.
You have to specify "delete from test.dbf" in the execute sql task if
test.dbf is your file.
Then right click and execute. it works!

Regards

Partha Mandayam
Software Consultant
Home page: http://partha.tripod.com


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!