+ Reply to Thread
Results 1 to 2 of 2

SSIS Package to pull data from Webservice (Internet Explore URL)

  1. #1
    Valued Forum Contributor Parth007's Avatar
    Join Date
    12-01-2014
    Location
    Banglore
    MS-Off Ver
    2010
    Posts
    825

    SSIS Package to pull data from Webservice (Internet Explore URL)

    Hello Experts,

    Need your suggestion in order to have a work-around on below

    SQL SERVER 2008
    I am creating a SSIS package which will pull data from WebService, but while connecting to the link
    http://www.webservicex.net/country.asmx?WSDL

    I get error - "Unable to connect to the remote server"

    I also get a popup from Interactive Service Detection stating -
    "The program might need information from you or your permission to complete a task"

    "SQLAGENT.exe needs your attention"

    "The problem occurs when a program is not fully compatible with windows.
    Please contact the program or device manufacturer(s) for more information.



    Please suggest/assist
    Regards
    Parth

    I appreciate your feedback. Hit * if u Like.
    Rules - http://www.excelforum.com/forum-rule...rum-rules.html

  2. #2
    Valued Forum Contributor Parth007's Avatar
    Join Date
    12-01-2014
    Location
    Banglore
    MS-Off Ver
    2010
    Posts
    825

    Re: SSIS Package to pull data from Webservice (Internet Explore URL)

    I have done all RnD like starting stopping restarting SQL AGENT as well as all required SERVICES
    Also I have RPC 135 p[ort open for the same..


    still nothing working on... last option reinstall SQL SERVER 2008.. but will this solve the issue?

    its client database server, I can reinstall having backups of database & then restoring them..

    but main concern is SSIS Package to pull data from Webservice (Internet Explore URL)

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1