将输入参数从sql表传递给存储过程 [英] pass input parameters to stored procedure from sql table

问题描述

我想在表 T1 中传递开始日期和结束日期等输入参数，并从 T1 传递给存储过程 SP1.这可能吗，我还想在 ssis 的 c# 脚本任务中执行这个 sp.谢谢

i want to pass input parameters like start date and end date in the table T1 and pass to stored procedure SP1 from T1.is it possible,and also i want to execute this sp in c# script task in ssis.Thanks

推荐答案

我已经解决了最初的问题 我接受了执行 sql 任务并从表中选择值并将这些值存储在结果集中，然后我已经采取数据流任务和oled源连接并执行其中的sp并将较早的结果集值传递给存储过程并执行它并将rsult存储在一个sql表中.

Hi i have sort out the problem initially i took the execute sql task and select the values from the table and store those value in the result set an after that i have taken dataflow task and oled source connection and execute the sp in that and pass the earlier result set values to the stored procedure and execute it and store the rsult in the one sql table.

这篇关于将输入参数从sql表传递给存储过程的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！