Hi
The only way to allow someone to create a DTS package is through
Enterprise Manager. Perhaps you can block all servers/databases if it
is a permission issue.
Suzy
Adam wrote:
How can I install DTS without having to install Enterprise Manager in SQL
Server 2000?
From the options given through the installation process, it seems I have to
install EM in order to have DTS but my understaning is that DTS is a seperate
client tool which comes with SQL Server. I don't want to install EM on a
developer's machine.
Re: DTS services import process terminating ... It could be that the failed install of your AV product has corrupted ... I would start by reregistering the DTS dlls... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)... (microsoft.public.sqlserver.dts)
Re: ActiveX DTS not working on Schedule ...DTS package.... comes with SQL Server due to the bug in 2000 which corrupts the DTS ... ' This script uses FTP to move a file from the transfers directory ... If not errorlevel 1 If not errorlevel 2 goto 226_ok ... (microsoft.public.sqlserver.dts)
Unable to enlist in the transaction. ... When i execute the same DTS job on another server not running SQL Server I ... Unable to enlist in the transaction....Help file: sqldts80.hlp ... (microsoft.public.sqlserver.dts)
Re: using access schema ini with DTS ... and yes I refresh the access database... ...SQL Server and with a scheduled event. ... Col2="PartNumber" Char Width 16 ... Underneath the covers of a DTS... (microsoft.public.sqlserver.dts)
RE: DTS fails to import data when called from VB6 ... have also installed MS Access on the server.... Within the VB code I execute 2 DTS packages ... Note that if the DTS packages are executed manually on the ... >> I have created a DTS package that imports an Access ... (microsoft.public.sqlserver.dts)
