dbTalk Databases Forums  

Transfer DTS package

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Transfer DTS package in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
hb_zhang
 
Posts: n/a

Default Transfer DTS package - 11-06-2003 , 02:11 AM






How can i transfer a DTS package (the job run well on
server1)from server1 to server2,
i try open 1 package from server1 and then save the
package to server2. I can run the package on CMD use
DTSRun and on SQL Enterprise Manager, but while i schedule
the package as job , the job on server2 can start but it
keep running status till manually stop it.

Reply With Quote
  #2  
Old   
Hon
 
Posts: n/a

Default Transfer DTS package - 11-06-2003 , 04:25 AM






1. if you want to transfer many DTS packages from one
server to another you can use the DTSBackup 2000 tool. can
download from www.sqldts.com

2. modify your schedule job and go to steps click on the
step then specify the output file name. the output file
show the detail of the process. hope it will help

Quote:
-----Original Message-----
How can i transfer a DTS package (the job run well on
server1)from server1 to server2,
i try open 1 package from server1 and then save the
package to server2. I can run the package on CMD use
DTSRun and on SQL Enterprise Manager, but while i
schedule
the package as job , the job on server2 can start but it
keep running status till manually stop it.
.


Reply With Quote
  #3  
Old   
hb_zhang
 
Posts: n/a

Default Transfer DTS package - 11-09-2003 , 08:06 PM



Hon,

Thanks.

I try to use the DTSBackup 2000 tool, but no change.
and i try specify the output file, nothing record in the
file.

Please give me more help.

Best regards

HB

Quote:
-----Original Message-----
1. if you want to transfer many DTS packages from one
server to another you can use the DTSBackup 2000 tool.
can
download from www.sqldts.com

2. modify your schedule job and go to steps click on the
step then specify the output file name. the output file
show the detail of the process. hope it will help

-----Original Message-----
How can i transfer a DTS package (the job run well on
server1)from server1 to server2,
i try open 1 package from server1 and then save the
package to server2. I can run the package on CMD use
DTSRun and on SQL Enterprise Manager, but while i
schedule
the package as job , the job on server2 can start but it
keep running status till manually stop it.
.

.


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.