Copy DTS Packages from One server to another

#1

I need to copy the actual package and not the data.

#2

http://www.sqldts.com/?204

--
Jacco Schalkwijk
SQL Server MVP

"Bob Smith" <simian888 (AT) hotmail (DOT) com> wrote

Quote:

I need to copy the actual package and not the data.

#3

Dear

just open the package. right click any where and select saveas option. In saving dialog box, enter the new server name and login authentication.

this method helps u in dts by dts level.

if u want to copy all dts(s) or jobs(s) from one server to other server, use 'jobs copy' task in dts package.

Bye
Srinivas

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Copy DTS Packages from One server to another

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

Copy DTS Packages from One server to another - 12-18-2003 , 10:15 AM

Re: Copy DTS Packages from One server to another - 12-18-2003 , 04:51 PM

Re: Copy DTS Packages from One server to another - 12-19-2003 , 05:46 AM