使用SSIS将数据从C#数据表导入SQL Server表

问题描述:

希望使用SSIS包将存储为变量的C#数据表中的数据传输到SQL Server中的表。我的查询是,



如何使用SSIS将数据从变量拉入SQL Server,用于相同的组件

Wish to transfer data from a C# data table stored as a variable to a table in SQL Server using a SSIS package. My query is,

How to pull data from the variable into SQL Server using SSIS, what components to use for the same





在这里,我找到了几个可以帮到你的链接,



将DataSet传递给SSIS包 [ ^ ]



所以你的代码就像,

Hi,

Here i found couple of links that may help you,

Passing DataSet to the SSIS Package[^]

So your code would be like,
Variables variables = package.Variables;
variables["MySSISVariable"].Value = myDataSet;



我还没累,但看起来很有希望。



最好运。


I have not tired yet but it looks promising.

Best Luck.