Can an end user exec a DTS Package?

#1

SQL2K
SP4

Is there a way that an end user can exec a DTS Package from an application?
I don't want to allow them xp_cmdshell or anything like it, so Im at a bit of
a loss.

TIA, ChrisR

#2

Use the COM based DTS library in your application to create an object of type
DTS.Package. Call its LoadFromSQLServer method to open the package saved in
SQL Server. Call its Execute method to run the package.

Charles Kangai, MCT, MCDBA

"ChrisR" wrote:

Quote:

SQL2K
SP4

Is there a way that an end user can exec a DTS Package from an application?
I don't want to allow them xp_cmdshell or anything like it, so Im at a bit of
a loss.

TIA, ChrisR

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Can an end user exec a DTS Package?

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Can an end user exec a DTS Package? - 08-24-2006 , 02:47 PM

RE: Can an end user exec a DTS Package? - 08-25-2006 , 08:54 AM