程式碼如下:
$date = get-date
$yyyyMM = '{0:yyyyMM}' -f $date
$yyyy = '{0:yyyy}' -f $date
$startdate=$yyyy +"01"
$enddate=$yyyyMM
$ssiscmd="dtexec /f """+"C:\Documents and Settings\Administrator\桌面\SSIS\SRQASSIS\SRQASSIS\MasterPackage.dtsx"+""" "+"""/SET \package.Variables[ProjectCode].Value;testproject"" "+"""/SET \package.Variables[SSYMFrom].Value;"+$startdate+""" "+"""/SET \package.Variables[SSYMTo].Value;"+$enddate+""""
invoke-expression $ssiscmd
沒有留言:
張貼留言