Results 1 to 2 of 2

Thread: Can I run DTS on server doesn't have SQL Server installed?

  1. #1
    Michael Guest

    Can I run DTS on server doesn't have SQL Server installed?

    Can I write DTS package to be used in VB app (NT service) that will be taking some text files, checking business rules on client, then inserting records to SQL server on remote server (via TCP/IP)?
    If so, what licence/software requirements? Security concerns?

    Thanks,

    Michael

  2. #2
    JeffP Guest

    Can I run DTS on server doesn't have SQL Server installed? (reply)

    Michael,

    Yes, install the desktop edition of MSSQL. This will give you the Enterprise manager and DTS, but you cannot host a db locally on this system.

    HTH

    JeffP...


    ------------
    Michael at 11/16/2001 6:14:02 PM

    Can I write DTS package to be used in VB app (NT service) that will be taking some text files, checking business rules on client, then inserting records to SQL server on remote server (via TCP/IP)?
    If so, what licence/software requirements? Security concerns?

    Thanks,

    Michael

Posting Permissions

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