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

  • 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

  • Yes it will run. Security concerns are same as always, restrict access to your tables using standard permissions, logins, etc. I'm not sure about licensing, I "think" if you've got a server installed you're ok - Steve?

    Andy

  • Yes, but the server where it will be running doesn't have SQL server installed.

  • Found this in redist.txt on the SQL install CD, shows while files you can redistribute freely (there are more, just DTS list presented here).

    Data Transformation Services (DTS)

    ----------------------------------------------

    File NameDescription

    ----------------------------------------------

    sqlresld.dllSatellite Resource DLL Loader

    dtsffile.dllDTS Flat File OLE DB Provider

    dtsffile.rllDTS Resource File

    dtspkg.dllDTS Package

    dtspkg.rllDTS Resource File

    dtspump.dllDTS Datapump

    dtspump.rllDTS Resource File

    axscphst.dllDTS ActiveX Script Host

    axscphst.rllDTS Resource File

    dtsrun.exeCommand Line Utility to Execute a DTS Package

    dtsrun.rllDTS Resource File

    sqlunirl.dllSQL Server Unicode/ANSI Translation Layer

    custtask.dllDTS Custom Tasks File

    custtask.rllDTS Custom Tasks Resource File

    Andy

  • I think you can redistribute these just like Access runtime.

    Steve Jones

    steve@dkranch.net

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply