Uploading a file into a website using SSIS

• prasadau2006

  SSC-Addicted

  Points: 408

  More actions

  March 14, 2012 at 5:04 pm

  #254763

  Hi,

  Can any one guide me how to upload a xml file into a website using SSIS? Is it possible to upload?

  Thank you

  Prasad

• Koen Verbeeck

  SSC Guru

  Points: 259165

  More actions

  March 15, 2012 at 2:01 am

  #1459667

  With SSIS you can drop files into a shared folder.

  It's up to the code of the website to pick that file up.

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

• Derek Robinson

  Mr or Mrs. 500

  Points: 594

  More actions

  August 1, 2012 at 9:42 am

  #1520365

  Koen answer is pathetic and folks should not comment on things they know nothing about. A file share relies on a mutual internal server and that's not what most web services are about.

  If your web service can produce a WSDL file (basically a description of the input parameters and datatypes) then you can use the web service task.

  If not, or you want to send the data in a data flow check out http://blogs.conchango.com/jamiethomson for code and a very good video of how this can be done.

  I hope this helps.