What about using DTSRUN and windows scheduler
The DTS runtime is with MSDE and Agent but no Gui Tools so you could create a job using the procs and osql.
--
Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - SQL Server 2005 Integration Services.
www.Konesans.com
"inquisite" <inquisite (AT) discussions (DOT) microsoft.com> wrote
Quote:
I have .dts file from another sql server. I would like to import and install
this file as a DTS package on MSDE and schedule it to run periodically.
How do I do this in MSDE 2000.
|
Import and Schedule DTS on MSDE -
11-23-2004
, 05:11 PM
Linear Mode
