Trigger and Package

[k2kataria]

Hey Guys!

A quick question. I need to call a package from a trigger. The need being, I want to get the result set of a query, do some manipulation on it and generate a text file in custom format. This process needs to be triggered from the table rather than being a scheduled process. Is there a way I can call an sql package from a trigger???

Ketan

[rmiao]

Can try call dtsrun with xp_cmdshell or create job for the package and run the job with msdb..sp_start_job.

[skhanal]

What do you mean by a package?. Is it a script file or a DTS package?

For both cases you will have to open command shell using xp_cmdshell. If it is a script file then run osql.exe for dts run dtsrun.exe

[MAK]

you can use sp_oamethod to call a procedure if you are not comfortable in using xp_cmdshell.