SSIS 在运行时设置变量 [英] SSIS set variable at runtime

问题描述

有人知道如何在运行时更改 SSIS 变量吗?

Anyone know how I can change a SSIS variable at runtime?

我有一个变量 User:SkipStuff

I have a variable User:SkipStuff

我想根据 for 循环容器期间的条件进行设置

I want to set this based on a condition during a for loop container

推荐答案

您可以添加脚本任务.将您的 SSIS 变量添加到脚本任务编辑器中的 ReadWriteVariables 属性.

You can add a Script task. Add your SSIS variable(s) to the ReadWriteVariables property in the Script Task Editor.

您可以使用以下格式在脚本中引用变量:Dts.Variables["MyCaseSensitiveVariableName"].Value

You can reference the variable(s) in your script using the following format: Dts.Variables["MyCaseSensitiveVariableName"].Value

这篇关于SSIS 在运行时设置变量的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！