开发者

Passing Variable in SSIS

开发者 https://www.devze.com 2023-01-19 06:07 出处:网络
I need some help to pass row value to the other task in SSIS package. Here is my sample query select distinct txnno from tbltxn, what I need is to get distinct txnno from this query and delete records

I need some help to pass row value to the other task in SSIS package. Here is my sample query select distinct txnno from tbltxn, what I need is to get distinct txnno from this query and delete records from other table based on this txnno. I think we can p开发者_如何学编程ick txxno in some variable in a foreach in a container and pass that recordset value to the query which is used to delete.But I have not done this before, so I need some clues and examples to solve this problem.


Here you go - the documentation includes a link to samples on Codeplex:

http://technet.microsoft.com/en-us/library/cc280492.aspx

0

精彩评论

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