>Is there an easy way to execute a DTS package for a simple export with a query, SP, or WMI?
>
>Thanks

Not an easy way: you can call the DTSRUN utility from xp_cmdshell but you will need to have sysadmin permissions, or have been given permissions to use xp_cmdshell. I don't know if there are new options to run packages in SQL2000.

The easiest way IMO is to schedule the package by right-clicking on it and selecting "Schedule Package".