使用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.