Win NT4.0 + SQL2000 => DTS error

From: Dave (peakman@sympatico.ca)
Date: 04/14/03


From: "Dave" <peakman@sympatico.ca>
Date: Mon, 14 Apr 2003 10:11:03 -0700


Hi everyone.
 I have some trouble to make some DTS package on a SQL
server. It can be a 2000 or a 7.0 I've got the same
trouble. When I try to make or design a DTS package, it
appear this error :

error source: Microsoft Data Transformation services (DTS)
package
error description : Accès refusé

in english "Accès refusé" mean "access refuse"

I don't know why it's make this error on a win NT station
but not on a win 2000 station... I've try with a lot of
win NT station and it's make all the same error. But if i
try with other computer with the os of win 2000, there is
no error. why?

In addition, I try directly on the server that have the
sql server 7.0 with the enterprise manager (7.0)(win NT
workstation) and it's make the same error.

Can someone can help me?

excuse me for my english... my first language it's french

Dave



Relevant Pages

  • global variable not working
    ... which sets a global variable in the DTS package and then the stored procedure ... It all works on the development server! ... problem I am having is that I have moved the DTS package up to our Test sql ...
    (microsoft.public.sqlserver.dts)
  • RE: Multiple loops in one package?
    ... this is not currently support in SQL 2000 DTS package. ... | I know how to loop through one set, but wasn't sure if there was an easy ... | Get next server from Server recordset --a ...
    (microsoft.public.sqlserver.dts)
  • Re: Where is it #2?
    ... Also I have had a load of ... trouble before and it was because I do not have any SQL. ... of it until I reinstalled the (OS Server 2003. ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: DTS Packages fail when executed from Jobs
    ... I have tried running the DTS package on the server whilst logged on as the ... DTSRUN.EXE or through the SQL Server Enterprise Manager. ... >> I am having trouble executing a DTS package from a SQL Job. ...
    (microsoft.public.sqlserver.dts)
  • RE: DTS, .NET and remote servers
    ... Server A is running SQL 2000 and in domain X ... Server B is running IIS and host web-sevvice, ... I wish my web-service to trigger a DTS import on server A. The ... demonstrating the DTS package is loaded and accessible on Server B). ...
    (microsoft.public.sqlserver.dts)