Re: Another DTS Scheduling question

Tech-Archive recommends: Fix windows errors by optimizing your registry

Allan,

Yes it's installed on the server. The emails work fine if I execute
the steps from within the dts package but I get the error when I run
the scheduled job.

.

Relevant Pages

  • Re: DTS vs Job Problem for 2 Digit Date format
    ... The DTS & The job is execute directly on the server? ... Norm ... When you execute a DTS package it comes to you. ...
    (microsoft.public.sqlserver.dts)
  • Re: Executing DTS from Code (correction)
    ... Granting execute permissions on these procs means that external Com objects can be called etc. ... If they run in-process and crash then bye-bye SQL Server. ... I moved the DTS package to the production server and>>> installed the application on the production server. ...
    (microsoft.public.sqlserver.dts)
  • 6 Overflow error while executing DTS Package from VB DCOM
    ... I am facing one very weird problem while executing the DTS package from VB ... It occures when it tries to execute below ... We have one DB Server and Web server. ... Some memory issue but there is no entry in SQL log and event log specific ...
    (microsoft.public.sqlserver.dts)
  • Re: DTS vs Job Problem for 2 Digit Date format
    ... When you execute a DTS package it comes to you. ... The job will execute on the server itself. ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ...
    (microsoft.public.sqlserver.dts)
  • Re: Executing DTS from Code
    ... No one will be executing the code from the server, ... > and execute the proc. ... >> package. ... >> runs the DTS package. ...
    (microsoft.public.sqlserver.dts)