Re: dtsrun fails inside a job

From: Uri Dimant (urid@iscar.co.il)
Date: 06/27/02 

From: "Uri Dimant" <urid@iscar.co.il>
Date: Thu, 27 Jun 2002 08:15:42 +0200

Hi,Raks
I am using dts as a part of job but i don't have these problems
look at this two important things
1) Type---- Operationing System command(CMDEXEC)
2) Command -------dtsrun /Sname_server/Usa /Ppassword /Ndts_name

Raks <raksql@hotmail.com> wrote in message
news:94871109.0206261930.21590356@posting.google.com...
> 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: DTSRun and Batch file
    ... >> install the DTS DLLs on the local machine. ... So the DTS package is running ... >> user to start a SQL Agent Job that runs the package. ... Darren Green (SQL Server MVP) ...
    (microsoft.public.sqlserver.dts)
  • Re: Error when running SQL 2000 dts Package in SQL Server 2005
    ... Lotus SQL Driver works fine. ... created a package in SQL 2000 and trying to call it in SQL 2005'S Legacy Data ... I am able to create a new table using this DTS ... OK so if this fails when you use the package in an Execute DTS 2000 Package ...
    (microsoft.public.sqlserver.dts)
  • Re: Scheduling DTS Packages on 64-bit SQL Server
    ... My understanding is that DTS components are not available for 64-bit SQL ... > I found the following comment on Microsoft's website in regards to scheduling> a DTS package on a 64-bit SQL Server installation. ... do I need> to buy a 32-bit copy of SQL Server to store my packages on to be able to> schedule them? ...
    (microsoft.public.sqlserver.dts)
  • Error invoking a DTS package remotely
    ... I ran into a problem invoking a DTS package from a different machine. ... invoke the package from another machine with only sql 7 on it. ...
    (microsoft.public.sqlserver.dts)
  • RE: Sheduling DTS-Packages in SQL2005
    ... If you have downloaded and installed the SQL 2005 Legacy Components (should ... also be on the install medial) you should be able to manage, edit, and run ... To schedule the package, create a stored procdure wrapper that executes the ... T-SQL syntax for executing DTS.) ...
    (microsoft.public.sqlserver.dts)