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

You do not tell us what your package contains but I am guessing thaat it is
DataPump task which as you have discovered will take across dat (AND)
table definitions. To move procs you can use the Copy SQL Server objects
task OR you can simply script out the procs from EM and apply the script
through QA to the remote server.


--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com - Consultancy from the people who know


"dan" <dea (AT) deamon (DOT) com> wrote

Thank you very much for your very prompt replies!
Actually I used the Copy SQL Server objects task. What went wrong?
I will try the second method after I will find out how exactly to script out
procs.
Thanks again,
Dan




"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote