Run the package using trigger

[Jazzy_J]

Hi ALL,

How 2 run a DTS pkg automatically based on a table value

For ex:

Table T(has only 1 field) gets value '101'(count==1 or n) based on a trigger...Further, the package P shud run automatically, advantage here is the table gets truncated automatically through some .NET application. So, again whenever the table T gets the value(s), the pkg P shud run without any manual work

Please let me know the solution, Thanx in advance

[rmiao]

You can create a sql job to run the package and start the job with msdb..sp_start_job in your trigger.

[Jazzy_J]

Hi rmiao,

Thanx for the help, i tried it...but the problem is this that whenever the Table T gets value,Pkg P it shud run..so, plz help me regrarding this

Tahnx,
Jazzy_J

[rmiao]

Sql will not do that for you automatically, you have to write something (like insert trigger) to make it work.

[kunal]

hi
one questions -----
what is the main different b/w windows authentication and sql server authentication.


thanks

kunal

[rmiao]

Windows authentication uses current domain or local windows account for sql connection, while sql authentication uses standard sql login. Check books online if need more details.