DTS

What is the easiest way to give a user the abilitiy to run a DTS package
without having the Enterprise Manager on their workstation?I'm no expert my any stretch...I think there's an option to save your DTS
package as a Visual Basic executable file. If I remember correctly, this
option is provided while you go through the import/export wizard.
"Johnny" wrote:

> What is the easiest way to give a user the abilitiy to run a DTS package
> without having the Enterprise Manager on their workstation?|||Hi
Does the user have QA on his/her workstation?
"Johnny" <Johnny@.discussions.microsoft.com> wrote in message
news:5EAD6100-98E2-4378-B38D-D3BB8F059CE0@.microsoft.com...
> What is the easiest way to give a user the abilitiy to run a DTS package
> without having the Enterprise Manager on their workstation?|||> What is the easiest way to give a user the abilitiy to run a DTS package
> without having the Enterprise Manager on their workstation?
They need to have the dts runtime on their computer, then you can call
dtsrun.exe from the command line, for more info look in BOL.
If you wish to call a dts package from a sql script you can use
xp_cmdshell..