I currently have an Access DB that stores 4 seperate
modules that are ran through macros that for the most
part clean up my file directory. Mostly deletes .tmp
files and files that are no longer needed.

We are now using SQL 2000 server as a backend DB. I have
to run these manually once a week or so. Basically
whenever I remember.

I have never created a DTS package and was wondering if
it is possible to have SQL automate this for me through a
DTS package. If so, could someone please guide me in the
right direction as to what I should look for or where I
could find some good resources on Access and DTS.

Thanks

Yes it is. You will want to emulate what you do in the Access Macros and
put that into a piece of VBScript. How you run the VBScript is up to you
but your options include DTS (Active Script task) or VBScript job step (No
DTS). You can use the FileSystemObject to get to the Filesystem and play
with it. MS do not support Server side automation of Office but if all you
are doing is clearing up some directories we can get rid of Access doing
that.

Here is how to begin in DTS

Building a Package in the DTS Designer
http://www.sqldts.com/default.aspx?6,107,278,7,1

--


Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org