动态调用SSIS包

declare @cmd varchar(1000)
declare @sourceid int
set @sourceid = 2

declare @ssispath varchar(1000)

set @ssispath = '/SQL "/Package" /SERVER "TXCHEN/BANK" /MAXCONCURRENT " -1 " /CHECKPOINTING OFF'

select @cmd = 'dtexec ' + @ssispath + ''
select @cmd = @cmd + ' /SET /Package.Variables[用户::SourceID].Properties[Value];' + convert(varchar,@sourceid )+ ''

exec master..xp_cmdshell @cmd