SET PackageDir = D:\Job\Package
SET PackageName = Package.dtsx
SET ConfigDir = D:\Job\Config
SET ConfigName = date.dtsConfig
DTEXEC /F %PackageDir%\%PackageName% /CONFIGFILE %ConfigDir%\%ConfigName
/CHECKPOINTING OFF /REPORTING V
If you need to change the variable value in the package using batch you need to add following code
/SET "\Package.Variables[vServerType].Value";"P"
Full code:
DTEXEC /F %PackageDir%\%PackageName% /CONFIGFILE %ConfigDir%\%ConfigName /SET "\Package.Variables[vServerType].Value";"P" /CHECKPOINTING OFF /REPORTING V
Note: If this "vServerType" variable present in your config file , the value of this variable will not change during the execution time.
Note: If we use same Config file for different package,we should ensure the variables present in your config file whether present in package which are used.
SET PackageName = Package.dtsx
SET ConfigDir = D:\Job\Config
SET ConfigName = date.dtsConfig
DTEXEC /F %PackageDir%\%PackageName% /CONFIGFILE %ConfigDir%\%ConfigName
/CHECKPOINTING OFF /REPORTING V
If you need to change the variable value in the package using batch you need to add following code
/SET "\Package.Variables[vServerType].Value";"P"
Full code:
DTEXEC /F %PackageDir%\%PackageName% /CONFIGFILE %ConfigDir%\%ConfigName /SET "\Package.Variables[vServerType].Value";"P" /CHECKPOINTING OFF /REPORTING V
Note: If this "vServerType" variable present in your config file , the value of this variable will not change during the execution time.
Note: If we use same Config file for different package,we should ensure the variables present in your config file whether present in package which are used.
Hai job
ReplyDeleteI am Jijo jose studied with you in st. Pauls for pdc
How r you Please call me in this number 9447597923
Regards
Jijo