Hi All,

I'm new to the group and to SQL Server so bear with me.

Here's a little about my situation... I have to create interface files for
other programs that require dbf format files. All data is contained within
a SQL Server DB. I can create the file, and work with the file but after
deleting records from the file it does not purge(pack, compress, compact,
shrink, whatever) the file (file size continually grows). What I would like
to do is create the dBase file on the fly at run time in DTS.

I really don't want to get into external batch files being called and would
like to keep things neatly pacakged inside a DTS package. Anyone have any
pointers?

Thanks from a NEWBIE!

REM7600

I ended up doing a DROP TABLE and CREATE TABLE on the dBase connection.
Works well and no extraneous files. One downside is IF the file format
changes, you need to be sure to make the proper mods to the Create Table
statement.

REM7600

[quoted text, click to view]