SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Wizard
    Join Date
    Dec 2004
    Location
    USA
    Posts
    1,407
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    SQL Server data transfer and receipt question

    The application I am building needs to be able to:
    - automatically receive data from third parties
    - send data to third parties and wait to receive feedback from those third paries then integrate that recevied data into the database

    Is that DTS capability or is that more of an XML application issue?

  2. #2
    SitePoint Guru asterix's Avatar
    Join Date
    Jun 2003
    Posts
    847
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    MSSQL can do this in several ways, DTS especially:

    1) Send: Use FTP from DTS
    2) Send: Use Push Replication
    3) Send: Actually, pull, publish the data to a websit using IIS Virtual Directory for SQL Server

    Also you can write an extended stored procedure to manage whatever application you like, then schedule that to run using the Job Scheduler.

    More commonly, however, people would program a web service to publish the application interface and hide the database implementation from 3rd parties.

    HTH


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
  •