SSIS 2008: Sending huge volume of data to web service

• navaneeth.3ecsm

  SSC-Addicted

  Points: 449

  More actions

  February 8, 2012 at 7:31 am

  #145028

  Friends,

  There is a requirement in our project to send huge volume (more than 6 million records with 68 columns) of data to a web service (developed in JAVA). Also there is an expectation that this pushing process should get over in 30 mins (I'm not sure whether it is feasible within this time frame). The database and the webservice are in different servers.

  Can some one give me the best way of implementing this in SSIS?

  With Regards

  Navaneeth.S

• Koen Verbeeck

  SSC Guru

  Points: 259105

  More actions

  February 9, 2012 at 12:35 am

  #1444900

  There isn't really a "web service destination" in SSIS, so I think you're better of coding it in .NET. (or in another language)

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP