Interview Question in Data Transformation Services (DTS)
Interview Question :: How do you copy a dts job between sql 2000 servers
I think if you register both of the servers on Enterprise Manager, you can right-click on them, then click "All Tasks" - there's functions for copying tables so there might be some for copying DTS jobs.
Or, maybe, you can right click on the DTS job (like when you right click on a stored proc to "Generate Script"), and you can generate the script to reproduce it.
Loading ...