SSIS參數傳遞

SSIS參數傳遞

dtexec /FILE "d:\dt\Main.dtsx" /CHECKPOINTING OFF  /REPORTING EWCDI /SET "\Package.Variables[User::Package].Properties[Value]";FileImportFromFTP.dtsx    /SET "\Package.Variables[User::dbid].Properties[Value]";db  /SET "\Package.Variables[User::connpath].Properties[Value]";d:\dt\conn.csv /SET "\Package.Variables[User::gsysparm1].Properties[Value]";002 /SET "\Package.Variables[User::gsysparm2].Properties[Value]";L /SET "\Package.Variables[User::gsch_group_id].Properties[Value]";1