开发者

Making the Input Paramters of web service task dynamic inside SSIS pacakge

开发者 https://www.devze.com 2023-04-11 21:33 出处:网络
I have a call to a web service task inside of a for loop container in a SSIS 2008 package.I need t开发者_开发百科o pass a date as part of the web service input parameters.The date is calcluated based

I have a call to a web service task inside of a for loop container in a SSIS 2008 package. I need t开发者_开发百科o pass a date as part of the web service input parameters. The date is calcluated based on a variable in inside the for loop. I can calculate it as an expression, but I don't know how to make that expression the input parapmter. Is there another way to accomplish this?


I figured it out. I had to create a variable that had EvaluateAsExpression set to True. Then I created my expression

Making the Input Paramters of web service task dynamic inside SSIS pacakge

Then I passed the expression as the input parameter

Making the Input Paramters of web service task dynamic inside SSIS pacakge

0

精彩评论

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

关注公众号