dtsrun fails inside a job

From: Raks (raksql@hotmail.com)
Date: 06/27/02 

From: raksql@hotmail.com (Raks)
Date: 26 Jun 2002 20:30:40 -0700

I created a dts package and it seems to work well when i execute it
from the DTS designer. But when I use the dtsrun utility to run the
same package through a job the package fails. Also, to my surprise the
same dtsrun utility seems to work well when i run it in the command
prompt. It only fails when i make it part of a job. Any idea why this
is happening.
Also some additional info, I am using the sql 2000 tools to create and
edit the package....the server where i am storing this package is sql
7.0.
Has anybody come acros this problem ?

Help in this will be highly appreciated.

Thanks,
Raks

Relevant Pages

  • Re: DTS Designer without a server.
    ... You can design your DTS package locally (if it's a SQL to SQL ... On the target server richt click Data ...
    (microsoft.public.sqlserver.dts)
  • RE: DTSRun Call from Unix
    ... "There are two main methods of executing a DTS package from within T-SQL, ... either using the DTSRUN utility to perform the execution, ... fully documented in SQL Server Books Online. ...
    (microsoft.public.sqlserver.dts)
  • Re: Help with dtsrun and dts package.
    ... you need to have that on the box where the DTS package is ... What I have done is create an SQL database, ... Error string: The specified DTS Package ...
    (microsoft.public.sqlserver.odbc)
  • Re: Editing an SSIS package created by Import/Export Wizard
    ... SQL 2000 and migrated to a SSIS object in SQL 2005 or did you simply ... migrate it to a legacy DTS package within SQL 2005? ... I created the SSIS package using the BIDS ...
    (microsoft.public.sqlserver)
  • Re: How to open sql 2000 DTS package in sql 7?
    ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ... > Our partner created a DTS package in sql 2000. ...
    (microsoft.public.sqlserver.dts)