mmelanny
Član broj: 84308 Poruke: 23 *.mediaworksit.net.
|
da...u pitanju je DTS package...
probala sam da ubacim ovo u trigger:
DECLARE @hr INT, @oPKG INT, @Cmd VARCHAR(1000), @RetVal INT
DECLARE @PkgName varchar(256)
set @PkgName = "DTS1"
EXECUTE @hr = sp_OACreate 'DTS.Package', @oPKG OUT
IF @hr <> 0
BEGIN
PRINT ' ** Create Package Object Failed **'
PRINT ''
EXEC sp_OAGetErrorInfo @oPKG, @hr
RETURN
END
SET @Cmd = 'LoadFromSQLServer("(local)" ,"sa" ,"sa" ,0 , , , ,"' + @PkgName + '")'
EXEC @hr = sp_OAMethod @oPKG, @Cmd, NULL
IF @hr <> 0
BEGIN
PRINT ' ** Load Package Failed **'
PRINT ''
EXEC sp_OAGetErrorInfo @oPKG, @hr
RETURN
END
EXEC @hr = sp_OAMethod @oPKG, 'Execute'
PRINT @PkgName
PRINT @RetVal
IF @hr <> 0
BEGIN
PRINT ' ** Execute Package Failed **'
EXEC sp_OAGetErrorInfo @oPKG, @hr
--RETURN
END
ELSE
PRINT ' ** Execute Package Succeeded **'
EXEC @hr = sp_OADestroy @oPKG
IF @hr <> 0
BEGIN
PRINT ' ** Destroy Package Failed **'
EXEC sp_OAGetErrorInfo @oPKG, @hr
RETURN
END
Kada se okine trigger jednostavno zablokira i ne uradi nista, ali iz SP radi bez problema. Ima li neko pojma zasto?
|