March 14, 2012 at 5:04 pm
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
March 15, 2012 at 2:01 am
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
August 1, 2012 at 9:42 am
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.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply