Re: Server user 'ABC' is not a valid user in database 'msdb

You'd probably want to start by taking a look at the job
owner. The following article provides information needed to
run a DTS package from a job in both SQL 7 and SQL 2000:
INF: How to Run a DTS Package as a Scheduled Job
http://support.microsoft.com/?id=269074

-Sue

On Mon, 25 Sep 2006 07:30:01 -0700, batgirl
<batgirl@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

When I try to run a DTS package as a job, this is the error message I
receive. The user has db_datareader, db_datawriter and db_ddladmin rights.
All the DTS does is execute a stored procedure and put the results in an
excel file.
Any help is appreciated
Thanks
SS

.

Relevant Pages

  • Re: Help with dtsrun and dts package.
    ... I dropped the tables from the database and that took care of the table ... The SQL server 2000 being used to create the dts package is on a different ... the MSDE master database but the message is that you cannot restore a SQL ... Can I create a dts package without using SQL 2000 Enterprise manager? ...
    (microsoft.public.sqlserver.odbc)
  • Re: Job Scheduler fails and Managing Tempdb
    ... You can turn logging on on both the job and the DTS Package to get some more ... As I said in my previous post, shrinking tempdb is not very useful. ... SQL Server MVP ...
    (microsoft.public.sqlserver.programming)
  • DTS Package - Destination Server is now off of domain.
    ... The SQL Services were previously running as ... Now, my DTS package fails. ... - drop database DATABASENAME. ...
    (microsoft.public.sqlserver.dts)
  • DTS Package - Destination server is now off domain.
    ... The SQL Services were previously running as ... Now, my DTS package fails. ... - drop database DATABASENAME. ...
    (microsoft.public.sqlserver.security)
  • Problem using GLobal Variables in DTS Package
    ... I use SQL 2K on a Win2K box ... I have created a DTS package, the data source is a stored procedure with an ...
    (microsoft.public.sqlserver.dts)