schedule package problem

From: Elvira Zeinalova (elvira.zeinalova_at_sff.no)
Date: 06/21/04 

Date: Mon, 21 Jun 2004 14:19:08 +0200

Hi,
First of all I want to say "thanks" to KC and Alex for help.

I made DTS package to transfer datas between to servers ( both SQL Server
2000).
I tried to "Schedule Package" to run it ones a day. The system made a
"job", but when it runs - it fails with message"(reason: The system cannot
find the file specified)".

I can run this package manually - by "Execute Package" - everything is OK
then.
But I need to autorun it.

Please help...

Relevant Pages

  • Copy sprocs to a remote server
    ... My objective is to copy sprocs created on my desktop to a remote database. ... Both servers are registered in DTS. ... I have created a DTS package. ...
    (microsoft.public.sqlserver.dts)
  • RE: Copy Database from One SQL server to another fails
    ... Yes the user right are okay, using SA on SQL and Administrator on the windows ... 2003 servers. ... >> The DTS package was running fine till yesterday morning but now I am getting ...
    (microsoft.public.sqlserver.server)
  • Re: Run DTS as Scheduled Job
    ... Check that the SQL Agent service account has the correct permissions ... on all objects used by the DTS package (files, folders, servers, etc). ...
    (microsoft.public.sqlserver.dts)
  • RE: scheduled database transfer
    ... Have you tried linking the servers? ... This should allow the DTS package to connect ok. ... Regards, ... John Miceli ...
    (microsoft.public.sqlserver.dts)
  • Re: How to capture SQL statement messages in DTS log file
    ... I have several SQL Server 2000s and a couple of SQL Server 2005 servers ... Then instead of PRINT in your DTS package, ... The execution of the following DTS Package succeeded: ... Microsoft Online Community Support ...
    (microsoft.public.sqlserver.dts)