ERROR @ dosprompt with 'dtsrun'-commando....

[ruupy]

Hellow u all,

A short, simple problem has kept me from going 2 sleep...

I'm trying to start a DTS package with the 'dtsrun'commando at the dosprompt.

running :

C:\>dtsrun /S [servername] /U [loginname] /P [pasword] /N [dts-packagename]

or

C:\>dtsrun /S [servername] /U [loginname] /P [pasword] /N [dts-packagename] /M [packagepasword]


results in:

**************************************************
DTSRun: Loading...

Error: -2147217843 (80040E40); Provider Error: 18456 (4818)
Error string: Login failed for user 'xxxxxxx'
Error source: Microsoft OLE DB-provider for SQL Server
Help File:
Help context: 0
**************************************************

Does anybody have an idea as to how i can avoid this and run the package without errors????

ThenX for your time!!

GreetZ
RuupY

 

[tlbroadbent]

Error #18456 indicates the user does not have permission to login to the server. Your example shows brackets ([ and ]) around the DTSRUN paramaters. You need to remove them if present on your command line.

dtsrun /Sserver_name /Uuser_nName /Ppassword /Npackage_name /Mpackage-password

Otherwise, verify that the user_name and password are correct. Terry

People who don't take risks generally make about two big mistakes a year. People who do take risks generally make about two big mistakes a year. -Peter Drucker

 

[hudi]

Hi,

One another thing that Terry did not tell!

In case that your login on SQL server is windows authentication then your command line looks like:

dtsrun /S serverName /E /N packageName

/E stands for trusted connection

Andrej