Thursday, March 29, 2012

DTS Scripts

We are upgrading our current SQL2000 Server to new hardware. Is there a way
to transfer DTS packages from one server to another. Thanks.Open the package, in the package menu, select save as...you can save it to
file or directly to another server
"Tom Reis" <reistom@.cdnet.cod.edu> wrote in message
news:uq4MB3IuFHA.3568@.TK2MSFTNGP10.phx.gbl...
> We are upgrading our current SQL2000 Server to new hardware. Is there a
> way
> to transfer DTS packages from one server to another. Thanks.
>|||did you hear "Tom Reis" <reistom@.cdnet.cod.edu> say in
news:uq4MB3IuFHA.3568@.TK2MSFTNGP10.phx.gbl:

> We are upgrading our current SQL2000 Server to new hardware. Is there
> a way to transfer DTS packages from one server to another. Thanks.
>
http://www.sqldts.com/default.aspx?204
Neil MacMurchy
http://spaces.msn.com/members/neilmacmurchy
http://spaces.msn.com/members/mctblogs|||HOW TO: Move Databases Between Computers That Are Running SQL Server
http://support.microsoft.com/defaul...kb;en-us;314546
AMB
"Tom Reis" wrote:

> We are upgrading our current SQL2000 Server to new hardware. Is there a wa
y
> to transfer DTS packages from one server to another. Thanks.
>
>|||Hi,
Just open the DTS Package and save the package in text file it will be
saved as ii.DTS.
Copy that to another server and open the package and save in local
machine.
hope this help u
from
Doller

No comments:

Post a Comment