InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comMon, 20 May 2013 12:00:13 GMT20http://www.sqlservercentral.com/Forums/Topic1420080-364-1.aspx[quote][b]Carl Waitz (2/15/2013)[/b][hr]Interesting approach. Thanks for the reply. And you're right -- something like a Web Service Destination was what I was looking for. With your approach, how exactly would I pass the current variable record to the Web Service Task? Using the "Input" tab?[/quote]When you setup the inputs check the Use Variable box and set it to a valid variable name. In the ForEach Loop Container map the columns from your DataTable into those same variables.Fri, 15 Feb 2013 08:43:45 GMTopc.threehttp://www.sqlservercentral.com/Forums/Topic1420080-364-1.aspxInteresting approach. Thanks for the reply. And you're right -- something like a Web Service Destination was what I was looking for. With your approach, how exactly would I pass the current variable record to the Web Service Task? Using the "Input" tab?Fri, 15 Feb 2013 07:00:52 GMTCarl Waitzhttp://www.sqlservercentral.com/Forums/Topic1420080-364-1.aspxIt sounds like you are looking for a "Web Service Destination" Component inside the Data Flow Task but you will not find one there. How you might deal with it, without using a Script Component in your Data Flow setup as a Destination which might be the simplest way to go about this I think, is in your Data Flow Task capture the rows you want to send into the web service into a Variable of type Object, i.e. an ADO.NET DataTable. Then, back on the Control Flow use a ForEach Loop Container to iterate over the Variable that now contains a DataTable and call your web service using a Web Service Task inside the loop container.Fri, 15 Feb 2013 05:21:58 GMTopc.threehttp://www.sqlservercentral.com/Forums/Topic1420080-364-1.aspxI'm using the Web Service Task with no trouble to read, and my first assumption since I could see posting methods as an option was that I would be able to write records to the web service using it, but I only see how to read with it. Are there instructions some where?Thu, 14 Feb 2013 17:18:13 GMTCarl Waitzhttp://www.sqlservercentral.com/Forums/Topic1420080-364-1.aspxHave you looked into the [u][url=http://msdn.microsoft.com/en-us/library/ms140114.aspx]Web Service Task[/url][/u]? If so and you found it lacking can you describe more about what you are trying to do?Thu, 14 Feb 2013 16:53:15 GMTopc.threehttp://www.sqlservercentral.com/Forums/Topic1420080-364-1.aspxI'm still fairly new to SSIS and, though I have no trouble receiving records from a web service, I have been unable to discover how to write records to (i.e., post to) a web service from within SSIS other than, perhaps, scripting. Could someone point me to an article or other resource on how to post to a web service from SSIS? Thanks!Thu, 14 Feb 2013 07:52:26 GMTCarl Waitz