开发者

SSIS: Passing record set into a Stored Proc

开发者 https://www.devze.com 2023-03-28 21:17 出处:网络
I\'m using SSIS with SQL Server 2005, I want to pass a data set as a parameter into a sproc. Inside the sproc, I have to process the records and insert into some destination table.

I'm using SSIS with SQL Server 2005, I want to pass a data set as a parameter into a sproc. Inside the sproc, I have to process the records and insert into some destination table. Is there a direct way to do it in SSIS(passing data set as a parameter part)? Or do I've to convert the table records into XML and t开发者_C百科hen pass it as parameters..


I am not aware of any way to pass the entire data set into a stored proc (other than by converting to xml).

The alternative is to move your logic from your stored proc and set SSIS up to manage the destination logic.

0

精彩评论

暂无评论...
验证码 换一张
取 消