Run DTS package

[Marios Koumides]

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

[Simon Hayes]

"Marios Koumides" <ko******@gmail.com> wrote in message
news:f0**************************@posting.google.c om...

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

[koumides]

Simon Hayes wrote:

"Marios Koumides" <ko******@gmail.com> wrote in message
news:f0**************************@posting.google.c om...

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?

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