ssis れ襯 れ螻 語 蟆企.

dtexecui.exe dtexec.exe sql server job ssis れ襯 語 蟆曙 碁 れ 襷 . れ ろ 蟆 5豐 蟇碁Μ dtexecui.exe dtexec.exe sql server 2005 job agent ssis れ襯 語 蟆曙 1覿 蟆 蟇碁Πる 蟆企. 讒.. 企一襦 襷れ讌.. れ螳 襷朱 れ * 1覿企.. れ螳 60螳覃 1螳企.. 蟆螳 讓曙 襭朱 覃.. 讒..

蠏朱.. xp_cmdshell ssis襯 語覃 譟磯 觜襯企. 2008覯 job agent ろ覃 觜襯企. ui 覿瑚?

exec xp_cmdshell 
	'dtexec /FILE "C:\ssis\project\襷ろ壱れ.dtsx" /decrypt れ'
,	no_output 

伎? 覈襯碁. 讌貉.. 襦語り 覃讌襯 譯手覦 誤壱伎 讓曙 覓語企Μ..覃... UI覿瑚? 覃.. 覃讌 譟磯 襷螳?

.. 蠏谿朱 襷れ 覺る..
alter proc usp_dtexec
	@pkgNM varchar(1000)
,	@bExecDT char(8) = null
,	@eExecDT char(8) = null
,	@pkgPW varchar(255) = ''
as
/*
declare 
	@pkgNM varchar(1000)
,	@pkgPW varchar(255)
,	@bExecDT char(8)
,	@eExecDT char(8)

set @pkgNM = 'C:\ssis\project\れ_朱.dtsx'
set @pkgPW = ''
set @bExecDT = '20101103'
set @eExecDT = '20101128'
*/

if @bExecDT is null
begin
	set @bExecDT = convert(char(8), getdate()-1, 112)
	set @eExecDT = convert(char(8), getdate()-1, 112)
end

declare
	@cmd varchar(8000)


while(@bExecDT <= @eExecDT)
begin
	set @cmd = 
		'dtexec /FILE "' + @pkgNM + '" ' +
		'/de ' + @pkgPW + ' ' +
		'/SET "\Package.Variables[User::bExecDT].Properties[Value]";' + @bExecDT + ' ' +
		'/SET "\Package.Variables[User::eExecDT].Properties[Value]";' + @bExecDT

	exec xp_cmdshell @cmd, no_output
	print @cmd	
	
	set @bExecDT = convert(char(8), dateadd(dd, 1, @bExecDT), 112)
end