Yes, for now a schedule will work fine, thanks.
Terry
>>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".