November 16, 2001 at 4:31 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
November 16, 2001 at 6:58 pm
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
November 16, 2001 at 7:34 pm
Yes, but the server where it will be running doesn't have SQL server installed.
November 17, 2001 at 7:23 am
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
November 17, 2001 at 7:53 am
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply