-
Run the package using trigger
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
-
You can create a sql job to run the package and start the job with msdb..sp_start_job in your trigger.
-
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
-
Sql will not do that for you automatically, you have to write something (like insert trigger) to make it work.
-
hi
one questions -----
what is the main different b/w windows authentication and sql server authentication.
thanks
kunal
-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|