如何在ssis中动态传递变量 [英] how to pass the varibles dynamically in ssis

问题描述

如何在ssis中动态传递变量

how to pass the varibles dynamically in ssis

推荐答案

有多种方法可供选择将变量传递给SSIS ETL包并将值设置为包变量。



方法1：

1.使用SQL表存储变量值然后使用执行sql任务加载变量值来填充变量。

方法2：

2.在C＃代码中你也可以这样做





试试这个：

Microsoft.SqlServer.Dts.RunTime.Variables myVars = package.Variables;



myVars [MyVariable1]。Value =value1;

myVars [MyVariable2]。Value =value2;



Microsoft.SqlServer.Dts.Runtime.DTSExecResult results = package.Execute（null，myVars，null，null，null）;



问候，

Mubin Shaikh

Hi,

Various ways are there to pass variable into SSIS ETL package and set values to package variables.

Method 1:
1. Using SQL Table to store variable values and then Load variable value using Execute sql task to populate your variable.
Method 2 :
2. in C# code you can do this also


Try this:
Microsoft.SqlServer.Dts.RunTime.Variables myVars = package.Variables;

myVars["MyVariable1"].Value = "value1";
myVars["MyVariable2"].Value = "value2";

Microsoft.SqlServer.Dts.Runtime.DTSExecResult results = package.Execute(null, myVars, null, null, null);

Regards,
Mubin Shaikh

这篇关于如何在ssis中动态传递变量的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！