Re: DTS Transfer Job Fails

If you are just transferring jobs, why not script them and run the script at
the destination, after changing any server specific info you need?

--
Kevin Hill
3NF Consulting
www.3nf-inc.com



"dondraper40" <dondraper40@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:401B5369-4C82-4A6D-9F84-7C4C1C41E756@xxxxxxxxxxxxxxxx
I have an SA credentialed connection for both the source and destination
server. Both servers are SQL Server 2000 standard. The job fails with an
"unspecified error" which obviously is little help. I know it is
connecting
to both servers as it even shows me which jobs are already present on the
destination server and allows me to check only the ones that are not.

Are there any special issues that might cause this seemingly simple and
straightforward transfer? I do not yet have access to SISS so has anyone
had
success transfering jobs with that tool? Are there any other options or
third
party tools that can transfer jobs from one server to another?

Thanks,
Don


.

Relevant Pages

  • Re: Secure Form Script?
    ... > hijacking web forms? ... the destination address ... > such a script to change the destination address and point it at a list ... It's usually not sufficient to store the to addresses on the server ...
    (Focus-Linux)
  • PublishObjects lockup
    ... HOW CAN I MODIFY THIS SCRIPT TO PREVENT LOCKUP IN THE CASE OF FAILURE? ... Excel when the destination server for PublishObjects is not available. ...
    (microsoft.public.excel.programming)
  • RE: Secure Form Script?
    ... Or you can write your own script in Perl ... Even if manage to hijack the fields due to improperly vetted ... the destination ... > It's usually not sufficient to store the to addresses on the server ...
    (Focus-Linux)
  • Re: Same Internal Server Error from last two days
    ... I am trying to run a Hello World Perl Script in Apache 2.2. ... But its constantly giving me Internal Server Error.The script ... # have to place corresponding `LoadModule' lines at this location so the ...
    (perl.beginners)
  • Re: Same Internal Server Error from last two days
    ... I am trying to run a Hello World Perl Script in Apache 2.2. ... But its constantly giving me Internal Server Error.The script Runs perfectly fine from the command prompt. ... # This is the main Apache HTTP server configuration file. ... LoadModule actions_module modules/mod_actions.so ...
    (perl.beginners)