22,207
社区成员
发帖
与我相关
我的任务
分享
CREATE PROCEDURE proc_Test1_Insert
@id int
AS
declare @name nvarchar(500);
EXEC('exec master..xp_cmdshell ''dtexec /f "c:\Package.dtsx" /set \Package.variables[User::userId].Value;' + @id + '''')
GO
create trigger tgr_test1_insert
on [user]
after insert
as
declare @id int;
select @id = id from inserted;
--exec proc_Test1_Insert @id;
declare @cmd varchar(1000);
declare @ssispath varchar(1000);
set @ssispath = 'c:\Package.dtsx';
select @cmd = 'dtexec /F "' + @ssispath + '"';
select @cmd = @cmd + ' /SET \Package.Variables[User::userId].Properties[Value];"' + cast(@id as varchar) + '"';
exec master..xp_cmdshell @cmd;
go
你看看代码declare @cmd varchar(1000)
declare @ssispath varchar(1000)
declare @fileName varchar(1000)
set @ssispath = 'C:\temp\Package.dtsx'
set @fileName = 'C:\temp\test.csv'
select @cmd = 'dtexec /F "' + @ssispath + '"'
select @cmd = @cmd + ' /SET \Package.Variables[User::fileName].Properties[Value];"' + @fileName + '"'
exec master..xp_cmdshell @cmd