将变量从foreach循环传递给sql execute任务 [英] Pass the variable from a foreach loop into a sql execute task

问题描述

我想知道如何将变量循环中的变量传递给sql执行任务，在select语句中作为表名传递，这意味着我想从我从循环传递的@variable中选择* 。

解决方案

请参阅：

https://www.red-gate.com/simple-talk/sql/ssis/ssis-basics-介绍-foreach-loop-container /

和

https://www.red-gate.com/simple-talk/sql/ssis/传递变量到和从ssis-task /

i would like to know how to pass the varaiable from the foreach loop to the sql execute task, in the select statement as a table name, meaning i want to select * from the @variable that i am passing from the loop.

解决方案

Please see:

https://www.red-gate.com/simple-talk/sql/ssis/ssis-basics-introducing-the-foreach-loop-container/

and

https://www.red-gate.com/simple-talk/sql/ssis/passing-variables-to-and-from-an-ssis-task/

这篇关于将变量从foreach循环传递给sql execute任务的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！