Executing a DTS Package

#1

Hello

Is it possible to execute a DTS package from a Trigger. If so, can I also
pass a parameter to the package from within the Trigger.

Many thanks
David

#2

Hello D,

You could call the package from a trigger sure. The method by which you
call it decides how you pass a parameter.

DTSRun then you could use the /A switch.

Here are some thoughts though about DTS and triggers

http://www.sqldts.com/default.aspx?219

Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com

Quote:

Hello

Is it possible to execute a DTS package from a Trigger. If so, can I
also pass a parameter to the package from within the Trigger.

Many thanks
David

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

Executing a DTS Package

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

Executing a DTS Package - 02-14-2006 , 07:23 AM

Re: Executing a DTS Package - 02-19-2006 , 02:14 PM