General information
Forum:
Microsoft SQL Server
>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".
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only