My server has Windows 2000 Advanced Server as operating
system with SQL Server 2000 Enterprise Edition.

I would like to create a SQL Server DTS package to
automate the import of my daily performance monitor file.

My performance monitor file is created daily at 7:00 am
with the following name: DBGTY_csv_mmdd0700.csv.

The file is in the H:\Performance_Monitor directory.

I have set up DTS package to import the file into a SQL
Server table. But could figure away to automate the daily
loading from the performance monitor file to the SQL
Server table.

Please help me with this task.

Dan

You need to read up on SQL Server Agent and Jobs. This is the mechanism by
which we schedule stuff in SQL Server. There is a raft of information in
BOL about it.

Also

http://support.microsoft.com/?kbid=269074

--
--

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


"Dan" <anonymous (AT) discussions (DOT) microsoft.com> wrote

dts sounds a bit heavy for a simple import task.

To do this daily and a scheduled job.
Think about doing it va bcp which will be a lot simpler. You will probably want to archive as well.
see
http://www.nigelrivett.net/ImportTextFiles.html


"Dan" wrote: