How to copy DTS package?

I've created a DTS package. Then I want to copy it to another computer (not
networking/stand alone). My imagine, it can be copied to disc. So I can
rebuild it form its disc. Is My imagine right? or Can I do it?Open the DTS package, and From the 'Save as' option, save it as a .dts file.
Copy this .dts file to the target machine. Then open Enterprise Manager on
that machine, right click on 'Data Transformation Services' node, and select
'Open package' option. Then select this .dts package. Then save it again to
your target SQL Server.
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Bpk. Adi Wira Kusuma" <adi_wira_kusuma@.yahoo.com.sg> wrote in message
news:uUozdA%23jFHA.3900@.TK2MSFTNGP10.phx.gbl...
> I've created a DTS package. Then I want to copy it to another computer
> (not
> networking/stand alone). My imagine, it can be copied to disc. So I can
> rebuild it form its disc. Is My imagine right? or Can I do it?
>|||Thans, a lot of.
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
news:Odj3XT#jFHA.1416@.TK2MSFTNGP09.phx.gbl...
> Open the DTS package, and From the 'Save as' option, save it as a .dts
file.
> Copy this .dts file to the target machine. Then open Enterprise Manager on
> that machine, right click on 'Data Transformation Services' node, and
select
> 'Open package' option. Then select this .dts package. Then save it again
to
> your target SQL Server.
> --
> HTH,
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>
> "Bpk. Adi Wira Kusuma" <adi_wira_kusuma@.yahoo.com.sg> wrote in message
> news:uUozdA%23jFHA.3900@.TK2MSFTNGP10.phx.gbl...
>