Create Batch file to Execute SSIS Package

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.


1 comment:

  1. Hai job


    I am Jijo jose studied with you in st. Pauls for pdc

    How r you Please call me in this number 9447597923

    Regards
    Jijo

    ReplyDelete