Run DTS package

Hello !

I have a DTS package which I can run it fine from command line using
one SQL account who is not a also a user in the windows 2003
machine.If I try as another user that is a user or sysadmin account in
the box then I get a login error from OLE. Any ideas? When I use the
Enterprise Manager to run the package it runs fine regardless of the
user.


Many Thanks,
Marios Koumides

"Marios Koumides" <koumides@gmail.com> wrote in message
news:f0e6dfb6.0504180147.2807f984@posting.google.com...
> Hello !
>
> I have a DTS package which I can run it fine from command line using
> one SQL account who is not a also a user in the windows 2003
> machine.If I try as another user that is a user or sysadmin account in
> the box then I get a login error from OLE. Any ideas? When I use the
> Enterprise Manager to run the package it runs fine regardless of the
> user.
>
>
> Many Thanks,
> Marios Koumides

It's not really clear (to me) from your description exactly who is running
the package, and where it's executing. Are you running it with dtsrun.exe?
Are you running it on the server, or on your workstation? Can the users who
cannot run the package log in to MSSQL, or only to Windows? Are you using
Windows authentication or SQL logins for MSSQL? What exactly is the error
message? Which version of MSSQL do you have?

As a complete guess, the package contains MSSQL connection objects which use
Windows authentication, so it fails when you run it with a Windows user
which cannot log in to those MSSQL servers. But without more information,
that may be totally wrong.

Simon

Simon Hayes  wrote:
> "Marios Koumides" <koumides@gmail.com> wrote in message
> news:f0e6dfb6.0504180147.2807f984@posting.google.com... 
 using
 
in 
the 
the 
>
> It's not really clear (to me) from your description exactly who is
 running
> the package, and where it's executing. Are you running it with
dtsrun.exe?

I tried 2-3 users and they can run the package using dtsrun.exe but
providing a username and password different from theirs.(This username
and password is not a windows user but MS-SQL one)

> Are you running it on the server, or on your workstation?
Running it on the server.

> Can the users who  cannot run the package log in to MSSQL, or only to
>Windows?
They can log to both SQL and Windows

Are you using  Windows authentication or SQL logins for MSSQL? What
exactly is the  error

> message? Which version of MSSQL do you have?
>
Yes I am using windows authentication in MS SQL 2000.
The error message is they can't login MS SQL 2000

Many Thanks,
Marios Koumides

> As a complete guess, the package contains MSSQL connection objects
which use
> Windows authentication, so it fails when you run it with a Windows
user
> which cannot log in to those MSSQL servers. But without more
 information,
> that may be totally wrong.
>
> Simon