I wanted to transfer a job from one server to another.
That's what I did:

In DTS/local package, New Package -> Click on a Task
button called "Transfer Job Task". -> Set user names and
passwords on both tab of source and dest servers-> select
a job on third tab->Save it. Both are SQL 2000 and this
DTS package is generated in the destination server.

When "Execute" it, I got error messages from log as
following:

Could anybody help me with this. Thanks in advance!

================================================== ===

Error = -2147467259 (80004005) Error string:
Unspecified error Error source: Microsoft Data
Transformation Services (DTS) Package Help file:
sqldts80.hlp Help context: 700 Error Detail
Records: Error: -2147467259 (80004005); Provider
Error: 0 (0) Error string: Unspecified
error Error source: Microsoft Data Transformation
Services (DTS) Package Help file: sqldts80.hlp
Help context: 700

Whilst I do not use this task to transfer my jobs the error you are getting
suggests a permissions problem which could very well be an incorrect nam,e
being entered somewhere.

I personally script out jobs and change references to the local server to
the new server otherwise you get problems with the job thinking it comes
from a master server.



--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Jonathan Cao" <jonathan.cao (AT) nacalogistics (DOT) com> wrote

Thanks, Allan.
Where can find documentations regarding creating scripts
for this purpose? And/or do you have sample scripts?

No need for docs.

Either Right Click | All Tasks | generate Script on the Job Icon
OR
Right Click | All Tasks | generate Script on the Job Itself



--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Jonathan Cao" <joanathan.cao (AT) nacalogistics (DOT) com> wrote