Saving DTS Packages & Copying them to some other server...

I created some DTS Packages through EM on SQL Server 2000. Is there a way I
can generate scripts on those packages and execute the same scripts on some
other DB Server with the similar Database?
Any help in this regard is greatly appreciated.
Thanks & Regards,
RatnaRatna,
you can actually save the DTS package on to the other servers if accessible
in EM. Otherwise you can save them as file and transfer from there.
Quentin
"Ratna Garapati" <rgarapati@.hotmail.com> wrote in message
news:u1zVUPFjDHA.1332@.tk2msftngp13.phx.gbl...
> I created some DTS Packages through EM on SQL Server 2000. Is there a way
I
> can generate scripts on those packages and execute the same scripts on
some
> other DB Server with the similar Database?
> Any help in this regard is greatly appreciated.
> Thanks & Regards,
> Ratna
>|||On the Package Designer, you can do a Save As to another
server
or
you can save the package as Structured Storage File and
then open the .dts file and save it to the same server
Edgardo Valdez
MCSD, MCDBA, MCSE, MCP+I
http://www.edgardovaldez.us/
>--Original Message--
>I created some DTS Packages through EM on SQL Server
2000. Is there a way I
>can generate scripts on those packages and execute the
same scripts on some
>other DB Server with the similar Database?
>Any help in this regard is greatly appreciated.
>Thanks & Regards,
>Ratna
>
>.
>|||You can open the existing package in Design Package Mode in the current
server and then Package-->SAVE AS with Location "Structured Storage File".
Give a filename name of the package. You can copy this file to other SQL
Server machine and open this package.
"Ratna Garapati" <rgarapati@.hotmail.com> wrote in message
news:u1zVUPFjDHA.1332@.tk2msftngp13.phx.gbl...
> I created some DTS Packages through EM on SQL Server 2000. Is there a way
I
> can generate scripts on those packages and execute the same scripts on
some
> other DB Server with the similar Database?
> Any help in this regard is greatly appreciated.
> Thanks & Regards,
> Ratna
>|||Thank you guys.
Saving to a structured storage file is my option since I have to move these
packages to the servers at various locations. I tried it and I suceeded in
saving the file.
But how do I open that file as a package in the other server? I looked for
the options but I didn't find one.
Any help is appreciated.
Thanks,
Ratna.
--
"Edgardo Valdez" <edgardovaldez@.hotmail.com> wrote in message
news:079c01c38c57$ac6a31f0$a301280a@.phx.gbl...
> On the Package Designer, you can do a Save As to another
> server
> or
> you can save the package as Structured Storage File and
> then open the .dts file and save it to the same server
>
> Edgardo Valdez
> MCSD, MCDBA, MCSE, MCP+I
> http://www.edgardovaldez.us/
> >--Original Message--
> >I created some DTS Packages through EM on SQL Server
> 2000. Is there a way I
> >can generate scripts on those packages and execute the
> same scripts on some
> >other DB Server with the similar Database?
> >Any help in this regard is greatly appreciated.
> >Thanks & Regards,
> >Ratna
> >
> >
> >.
> >|||1. Open Enterprise Manager
2. Right Click on "Data Transformation Services"
3. Click Open Package
4. Open the package file (e.g, mypackage.dts)
"Ratna Garapati" <ratna.garapati@.sbcglobal.net> wrote in message
news:u5JHHoFjDHA.1132@.tk2msftngp13.phx.gbl...
> Thank you guys.
> Saving to a structured storage file is my option since I have to move
these
> packages to the servers at various locations. I tried it and I suceeded in
> saving the file.
> But how do I open that file as a package in the other server? I looked for
> the options but I didn't find one.
> Any help is appreciated.
> Thanks,
> Ratna.
> --
> "Edgardo Valdez" <edgardovaldez@.hotmail.com> wrote in message
> news:079c01c38c57$ac6a31f0$a301280a@.phx.gbl...
> > On the Package Designer, you can do a Save As to another
> > server
> >
> > or
> >
> > you can save the package as Structured Storage File and
> > then open the .dts file and save it to the same server
> >
> >
> > Edgardo Valdez
> > MCSD, MCDBA, MCSE, MCP+I
> > http://www.edgardovaldez.us/
> >
> > >--Original Message--
> > >I created some DTS Packages through EM on SQL Server
> > 2000. Is there a way I
> > >can generate scripts on those packages and execute the
> > same scripts on some
> > >other DB Server with the similar Database?
> > >Any help in this regard is greatly appreciated.
> > >Thanks & Regards,
> > >Ratna
> > >
> > >
> > >.
> > >
>