Home All Groups Group Topic Archive Search About

How to copy DTS package?

Author
23 Jul 2005 8:06 PM
Bpk. Adi Wira Kusuma
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?

Author
24 Jul 2005 12:15 AM
Narayana Vyas Kondreddi
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/


Show quote
"Bpk. Adi Wira Kusuma" <adi_wira_kus***@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?
>
>
Author
24 Jul 2005 1:53 AM
Bpk. Adi Wira Kusuma
Thans, a lot of.


Show quote
"Narayana Vyas Kondreddi" <answer***@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_kus***@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?
> >
> >
>
>

AddThis Social Bookmark Button