Copy sprocs to a remote server

From: dan (dea_at_deamon.com)
Date: 09/12/04 

Date: Sun, 12 Sep 2004 10:13:41 +0100

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. When run it displays the message
"successfully completed execution of package". However, none of the stored
procedures are actually copied to the remote server.
What could be the cause?
Thanks,
Dan

Relevant Pages

  • schedule package problem
    ... I made DTS package to transfer datas between to servers (both SQL Server ...
    (comp.lang.java.databases)
  • 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)