DTSRUN privileges?

I am trying to get a DTS package to be run from the command line with the dtsrun utility. The DTS package is stored in the database. The user I supply is a user in the database. I get an error stating "SQL Server does not exist or access denied." It looks to me like the SQL Server instance does exist because it tries to start the package. I get "DTSRun: Executing". If I put in a server that is non-existent, I do not get that message. I also know that my username and password are correct.

Here is output from my attempt to run dtsrun for my DTS pkg (server, user, password change to protect my db security):

C:\>dtsrun /Sserver_name /Uuser /Ppass /Npkg_name
DTSRun: Loading...
DTSRun: Executing...
DTSRun OnStart: DTSStep_DTSExecuteSQLTask_1
DTSRun OnError: DTSStep_DTSExecuteSQLTask_1, Error = -2147467259 (80004005)
Error string: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
Error source: Microsoft OLE DB Provider for SQL Server
Help file:
Help context: 0
Error Detail Records:
Error: -2147467259 (80004005); Provider Error: 17 (11)
Error string: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
Error source: Microsoft OLE DB Provider for SQL Server
Help file:
Help context: 0
DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_1
DTSRun: Package execution complete.


I suspect that my user I am connecting to the database with does not have privileges to execute the DTS package. I cannot determine, from BOL, what privs I need to grant to this user to let them execute this package. Any ideas?


TIA,
Brian




--
===================================================================

Brian Peasland
oracle_dba@xxxxxxxxxxxxxxxxxxx
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown
.

Relevant Pages

  • error on DTS scheduling
    ... I am pretty new to SQL server. ... I have setup a DTS package that would ... delete and then copy data from SQL server to DB2 on mainframe. ... DTSRun: Loading... ...
    (microsoft.public.sqlserver.server)
  • Re: DTSRUN privileges?
    ... be aware that the DTS package runs on same ... machine as DTSRUN. ... client machine and have specified SQL Server name 'local' in the DTS ... The DTS package is stored in the database. ...
    (comp.databases.ms-sqlserver)
  • Re: "Failed" Job runs DTS package
    ... pulls new data from a database on a different server. ... Now the DTS Package completes, but the Job says it failed. ... DTSStep_DTSExecuteSQLTask_2 DTSRun OnFinish: ... DTSStep_DTSExecuteSQLTask_2 DTSRun OnStart: ...
    (microsoft.public.sqlserver.dts)
  • Re: Running Legacy DTS on x64 2005 cluster
    ... At the moment I'm trying to run it under the Legacy Data Transformation ... Is your dts package within the SSIS execute DTS package task, ... DTSRun OnStart: DTSStep_DTSDynamicPropertiesTask_1 ... ActiveX Scripting was not able to initialize the script execution ...
    (microsoft.public.sqlserver.dts)
  • Re: Scheduled Job Fails with Error: "Login Failed for "sa"
    ... In article, Rebecca wrote: ... our DTS Package stopped running ... We also verifyied the SQL Server Agent ... DTSRun ...
    (microsoft.public.sqlserver.dts)