RE: Transfer DTS package from one Server to another

#1

Hello qjlee,

Here you go

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

Regards

Allan Mitchell
Konesans Ltd
T +44 7966 476 572
F +44 2071 008 479
http://www.konesans.com

Quote:

Actually, I am using sql 2000 and want to know how to do it within sql
2000.

Thanks,

"Todd C" wrote:

Open SSMS and connect to the Prodcution Server.
Navigate to the appropriate node (MSDB or File System)
Right Click and select Import
Select SQL Server or File System
Browse to the location of the desired package
I know, it's a little more overhead than v2000 DTS but they moved
more
toward a DEVELOPMENT environment than a DBA one. (What developer in
his right
mind edits a deployed version of a DLL file on a production server?
Same is
now true for SSIS. Develop it first, then deploy it.)
--
Todd Chittenden
"qjlee" wrote:

Hi,

I need to transfer all dts packages from my staging server to
production server. How I can do that?

What if I only want to transfer only one of them?

Thanks,

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

RE: Transfer DTS package from one Server to another

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

RE: Transfer DTS package from one Server to another - 11-30-2006 , 11:44 PM