Delete DTS package programmatically

#1

Is there a documented/safe way to programmatically delete a DTS
package?

OK then, how about an undocumented way?

Thanks.

Josh

#2

One option is to use the /!D argument for dtsrun.
See dtsrun in books online for more information.

-Sue

On Mon, 21 Mar 2005 17:27:05 -0800, JRStern
<jxstern (AT) bogus (DOT) com> wrote:

Quote:

Is there a documented/safe way to programmatically delete a DTS
package?

OK then, how about an undocumented way?

Thanks.

Josh

#3

Undocumented, for local storage packages only -

exec msdb.dbo.sp_drop_dtspackage .....

--
Darren Green
http://www.sqldts.com
http://www.sqlis.com
"JRStern" <jxstern (AT) bogus (DOT) com> wrote

Quote:

Is there a documented/safe way to programmatically delete a DTS
package?

OK then, how about an undocumented way?

Thanks.

Josh

#4

On Tue, 22 Mar 2005 08:32:18 -0000, "Darren Green"
<darren.green (AT) reply-to-newsgroup-sqldts (DOT) com> wrote:

Quote:

Undocumented, for local storage packages only -

exec msdb.dbo.sp_drop_dtspackage .....

Kewl!

thnx

J.

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

Delete DTS package programmatically

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

Delete DTS package programmatically - 03-21-2005 , 07:27 PM

Re: Delete DTS package programmatically - 03-21-2005 , 08:20 PM

Re: Delete DTS package programmatically - 03-22-2005 , 02:32 AM

Re: Delete DTS package programmatically - 03-23-2005 , 04:49 PM