SQL Server Performance Forum – Threads Archive
Web Service TaskHi All, In Sql Server 2005 Integration Service, I have created Web Service task which make calls WebMethod with parameter. I want to pass value for paramter to WebMethod in run-time when i am executing package in ASP.NET application. Please help me how to do this task and give me solution. Note: It is possible for me to call a WebMethod without Parameter in Web Service Task and can able to execute package in ASP.NET Application which is working fine.
See thishttp://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1099328&SiteID=1 is any help. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
This posting is provided AS IS with no rights for the sake of knowledge sharing.
First of all thanks for ur reply…I have gone thru this links..what i need is not covered..I want to pass value of parameter for the webmethod in run-time..<br /><br />Here is same code for Excuting Package in ASP.NET Appliction..This is code is working fine for webmethod without paramter…But i want to pass value in runtime..I am very new for SSIS..Do you any other alternativa way…<br /><br /><br />Code:<br />Application app = new Application();<br />Package objPack = [email protected]"D:SampleWorkSampleSSISSampleSSISinPackage.dtsx", null);<br />Variables vars = objPack.Variables;<br />//vars["User::Variable"].Value = "value from c#";<br />DTSExecResult result = objPack.Execute();<br />string strResult = vars["User:<img src=’/community/emoticons/emotion-7.gif’ alt=’:s’ />trResult"].Value.ToString();<br />