September 9, 2005 at 7:55 am
I need to copy to a new server existing DTS packages what is the easiest way to do this???? Thanks for any help
SQL Developer
James
Access Accounting Ltd
September 9, 2005 at 3:45 pm
In the past, I have bcp'd the sysdtspackages table out of the source server, and bcp'd it into the target server.
Hope this helps.
September 9, 2005 at 4:40 pm
September 12, 2005 at 5:02 pm
IMHO, the easiest way to move packages is to open them in DTS Designer on the source server and "save as" to the destination server.
Greg
Greg
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply