|
|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Display Modes |
|
|
|
Stay one step ahead of the competition. Evaluate and give feedback
on some of the hottest web development tools on the market today.
Make your opinion heard! Click
Here
|
|
#1
|
|||
|
|||
|
trigger+dts=problems? :-)
Hi!
I am trying to get a trigger to work like this; when a value in my database (quantity) goes below 5 then a dts package should be exported to a flatfile. I have also tried to write to a file from the trigger but it didn't seem to work, I could get text out and ONE value from the table but not like a whole row. Right now I am trying this, I have a dts package, saved in sql server. I have a trigger; CREATE TRIGGER trigge_update ON Artiklar FOR UPDATE AS if update (Antal) (right now I am just trying update) Execute komIgen then I have a stored procedure; CREATE PROCEDURE komIgen AS exec master..xp_cmdshell 'dtsrun /SKARIN2000 /NnuPaket /E' I hoped this would work, but then I read somewhere that if I use this dtsrun and xp_cmdshell, then I have to put NOLOCKS somewhere in Dynamic Properties Task. But I have no idea where to write NOLOCKS there.... I am a beginner so I like to keep it a bit simple...I mean, if I don't need eg. a stored procedure, then I don't want one, and if this is a a stupid way to do it then I gladely use something else. The thing is that I don't have Visual Basic right now so I can't try this thing with execute in VB. hope to hear from you, and please :-) write dummie answers to me, because as I said I am a Beginner. /Karin |
![]() |
| Viewing: Dev Articles Community Forums > Databases > Microsoft SQL Server > trigger+dts=problems? :-) |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|