将多个值从SQL Server代理传递到SSIS

I have 4 values that I need to pass from a SQL server Agent Job into my SSIS package. Here is my code from the CommandLine.

我有4个值,我需要从SQL服务器代理作业传递到我的SSIS包。这是来自CommandLine的代码。

(line breaks added for readability)

(为了便于阅读而增加了换行符)

/SQL "\"\DataWarehouse\Common\SSISPackageExecution\"" 
/SERVER "\"DEV-DS12\""  
/CHECKPOINTING OFF 
/SET "\"\Package.Variables[Control::SQLAgentJob].Value\"";"\"\"\"SSIS - Data Warehouse ETL\"\"\"" 
/SET "\"\Package.Variables[Control::Category].Value\"";"\"\"\"Dimension\"\"\"" 
/SET "\"\Package.Variables[Control::StartStep].Value\"";"\"\"\"10\"\"\"" 
/SET "\"\Package.Variables[Control::EndStep].Value\"";"\"\"\"20\\\"\"\"" 
/REPORTING E

I am working with SQL Server 2014, SSMS 2014, and VS 13 with 2014 datatools

我正在使用SQL Server 2014,SSMS 2014和VS 13以及2014数据工具

When I execute my Job is gives me this: Option "-" is not valid. The command line parameters are invalid.

当我执行我的工作时,给我这个:选项“ - ”无效。命令行参数无效。

My Property Paths are:

我的物业路径是:

• \Package.Variables[Control::SQLAgentJob].Value
• \Package.Variables[Control::Category].Value
• \Package.Variables[Control::StartStep].Value
• \Package.Variables[Control::EndStep].Value

My Values are:

我的价值观是:

• "SSIS - Data Warehouse ETL"

“SSIS - 数据仓库ETL”

• "Dimension"
• "10"
• "20"

1 个解决方案

#1

Remove the quote escaping:

删除转义的报价:

/SQL "\DataWarehouse\Common\SSISPackageExecution" 
/SERVER "DEV-DS12"  
/CHECKPOINTING OFF 
/SET "Package.Variables[Control::SQLAgentJob].Value";"SSIS - Data Warehouse ETL" 
/SET "Package.Variables[Control::Category].Value";"Dimension" 
/SET "Package.Variables[Control::StartStep].Value";"10" 
/SET "Package.Variables[Control::EndStep].Value";"20" 
/REPORTING E