Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

web service Expand / Collapse
Author
Message
Posted Thursday, December 26, 2013 10:19 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 3:45 PM
Points: 226, Visits: 1,026

I have a csv file that need to do a http post to a given URI of a remote web service using ssis. The web service transfers the file to the destination.All I need to do is have a mechanism in my ssis package to post the file to the webservice. Never done this before- could some one advise point me to the right direction. Thanks.
Post #1526000
Posted Thursday, December 26, 2013 12:13 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, August 28, 2014 9:59 AM
Points: 49, Visits: 588
try to use script task
Post #1526017
Posted Thursday, December 26, 2013 12:58 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 3:45 PM
Points: 226, Visits: 1,026
bangsql (12/26/2013)
try to use script task


Yup. I was more concerned about what should be in the script task.

I have been browsing and jumping around and two things come to mind WebClient or httpRequest ?
Post #1526025
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse