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

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