590
社区成员
发帖
与我相关
我的任务
分享
ALTER trigger [dbo].[tr_T1_Insert] on
[dbo].[Weather]
for insert
as
declare @sqlcmd nvarchar(2000)
declare @queryxml nvarchar(2000)
select @queryxml=i.city
from
inserted i
exec [dbo].[test] '4'
USE [Test]
GO
/****** Object: StoredProcedure [dbo].[test] Script Date: 09/21/2011 19:38:00 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[test](@queryxml nvarchar(50))
AS
BEGIN
declare @sqlcmd nvarchar(2000)
SET @sqlcmd = 'dtexec /DTS "\MSDB\SSis" /SERVER "YANCG-PC" /CHECKPOINTING OFF /REPORTING V /SET \Package.Variables[in].Properties[Value];"4" /SET \Package.Variables[city].Properties[Value];"4" '
exec xp_cmdshell @sqlcmd
END
select * from Weather