Hi All

I want to install the DTS package in client machine which is not located in my LAN. Upto now iam saving the DTS package as .dts file and copying that one in client machine manually. Is there any other way to install the DTS package in client machine.

Thanks,
Vasu.

Can you see the other machine? If not then a copy of something will need to be manually taken over there.

This could be as you mention a .dts file or it can quite easily be a text file containing output from msdb..sysdtspackages

If you could somehow let the two machines see one another then the transfer of sysdtspackages could be done using DTS itself.



--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"vasu" <vasu (AT) stcroixsystems (DOT) com> wrote

Hi All

I want to install the DTS package in client machine which is not located in my LAN. Upto now iam saving the DTS package as .dts file and copying that one in client machine manually. Is there any other way to install the DTS package in client machine.

Thanks,
Vasu.