+ 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
    879

    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
    879

    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)

Similar Threads

  1. how to retain the actual internet explore - window/tab size
    By prabhuduraraj09 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-26-2017, 03:25 PM
  2. Replies: 1
    Last Post: 11-16-2015, 11:24 AM
  3. Replies: 3
    Last Post: 06-03-2014, 12:53 PM
  4. Replies: 2
    Last Post: 02-17-2014, 08:18 PM
  5. How to stop the internet explore pop up ?
    By pari9485 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 10-11-2013, 08:10 AM
  6. CSV is coming in sorted order in SQL table through SSIS Package(SQL server)
    By Tusharp in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-18-2012, 09:02 AM
  7. code for saving file from Internet Explore
    By aravindhan_31 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-17-2011, 07:06 AM

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