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: Today @ 12:51 AM
Points: 243, Visits: 1,098

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: Tuesday, October 14, 2014 11:56 AM
Points: 49, Visits: 592
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: Today @ 12:51 AM
Points: 243, Visits: 1,098
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