_ | 覦覈襦 | 豕蠏手 | 殊螳 | 譯殊碁
FrontPage › Xp_cmdshell+Dtexec

declare
    @cmd nvarchar(4000)
,   @bdt char(8)
,   @edt char(8)
,   @path nvarchar(1000)
,   @pkg nvarchar(1000)
,   @return_code int
 
set @bdt = '20190801'
set @edt = '20190801'
set @path = '\SSISDB\Project01\DW\'
set @pkg = 'dim.test.dtsx'
 
set @cmd = N'""C:\Program Files\Microsoft SQL Server\130\DTS\Binn\DTExec.exe" /Server localhost /ISServer "@path@pkg" /SET "\Package.Variables[User::input_bdt].Properties[Value]";"@bdt" /SET "\Package.Variables[User::input_edt].Properties[Value]";"@edt" /Par "$ServerOption::SYNCHRONIZED(Boolean)";True'
set @cmd = replace(@cmd, '@bdt', @bdt)
set @cmd = replace(@cmd, '@edt', @edt)
set @cmd = replace(@cmd, '@path', @path)
set @cmd = replace(@cmd, '@pkg', @pkg)
print @cmd
 
exec @return_code = xp_cmdshell @cmd
print @return_code --0企 炎概

"譯殊"
/Par "$ServerOption::SYNCHRONIZED(Boolean)";True 襯 覿 return_code螳 襦 れ伎.


dtexec /package MyPackage.dtsx /project MyProject.ispac
蠍 蠍郁鍵..
企: : るジ讓曙 襦螻豺 企Ν 譯殊語. 襦螻豺
EditText : Print : Mobile : FindPage : DeletePage : LikePages : Powered by MoniWiki : Last modified 2019-12-09 11:00:41

襷 螳蠑碁 蟆 殊 螳蠑碁 蟆企. (觚襭 觜貅)