DTS package

Is there some way we can allow users to run DTS packages through an
application without sysadmin privilege?
You could use the DTS object model and do a
YourPackageObject.LoadFromServer
and
YourPackageObject.Execute
and then clean up your objects.
You can find examples at:
http://www.sqldts.com/default.aspx?104
-Sue
On Wed, 14 Sep 2005 17:21:03 -0700, "Eli Milkova"
<EliMilkova@.discussions.microsoft.com> wrote:

>Is there some way we can allow users to run DTS packages through an
>application without sysadmin privilege?
|||But to use sp_OAcreate and sp_OAmethod sysadmin membership is needed. what I
am missing?
"Sue Hoegemeier" wrote:

> You could use the DTS object model and do a
> YourPackageObject.LoadFromServer
> and
> YourPackageObject.Execute
> and then clean up your objects.
> You can find examples at:
> http://www.sqldts.com/default.aspx?104
> -Sue
> On Wed, 14 Sep 2005 17:21:03 -0700, "Eli Milkova"
> <EliMilkova@.discussions.microsoft.com> wrote:
>
>