How To Consume Web Service Through SSIS Package

9. Follow the below code. Here, I am passing the transactionID and amount to the ProcessData().
   
   
   1. #region Namespaces
   2. using System;
   3. using System.Data;
   4. using Microsoft.SqlServer.Dts.Runtime;
   5. using System.Windows.Forms;
   6. #endregion
   8. namespace ST_c02ad868b1314c3895bebfedd71e7fbf
   9. {
   10. /// <summary>
   11. /// ScriptMain is the entry point class of the script. Do not change the name, attributes,
   12. /// or parent of this class.
   13. /// </summary>
   14. [Microsoft.SqlServer.Dts.Tasks.ScriptTask.SSISScriptTaskEntryPointAttribute]
   15. public partial class ScriptMain : Microsoft.SqlServer.Dts.Tasks.ScriptTask.VSTARTScriptObjectModelBase
   16. {
   18. /// <summary>
   19. /// This method is called when this script task executes in the control flow.
   20. /// Before returning from this method, set the value of Dts.TaskResult to indicate success or failure.
   21. /// To open Help, press F1.
   22. /// </summary>
   23. public void Main()
   24. {
   25. // the below detail can be pulled from database and send to the service.
   26. long transactionID = 110011;
   27. decimal amount = 500.0m;
   29. ServiceManager.DemoService demoService = new ServiceManager.DemoService();
   30. try
   31. {
   32. var result = demoService.ProcessData(transactionID, amount);
   33. //based on result or status you can update the required table.
   34. //TODO
   35. Dts.TaskResult = (int)ScriptResults.Success;
   37. }
   38. catch (Exception ex)
   39. {
   41. Dts.TaskResult = (int)ScriptResults.Failure;
   42. }
   43. }
   45. #region ScriptResults declaration
   46. /// <summary>
   47. /// This enum provides a convenient shorthand within the scope of this class for setting the
   48. /// result of the script.
   49. ///
   50. /// This code was generated automatically.
   51. /// </summary>
   52. enum ScriptResults
   53. {
   54. Success = Microsoft.SqlServer.Dts.Runtime.DTSExecResult.Success,
   55. Failure = Microsoft.SqlServer.Dts.Runtime.DTSExecResult.Failure
   56. };
   57. #endregion
   59. }
   60. }

10. When you debug the SSIS package, you get the response from Web Service (refer the below screenshot).
    
    
    

Conclusion

SSIS provides the features by using a script component to consume the Web Service. And, it can be achieved by writing the custom code in SSIS.