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: Monday, April 14, 2014 3:12 PM
Points: 214, Visits: 929

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: 2 days ago @ 3:21 PM
Points: 41, Visits: 551
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: Monday, April 14, 2014 3:12 PM
Points: 214, Visits: 929
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