SQL Server 2005 Express DTS

#1

I realize that DTS isn't supported in 2005 Express. Is it possible to
use the DTS facility on an existing SQL Server 2000 installation in
order to push data to the Express installation? Many thanks -

#2

Absolutely. You just create a package with a connection object that
references the SQL Express insallation

--
David Lundell
Principal Consultant and Trainer
www.MutuallyBeneficial.com
David (AT) MutuallyBeneficial (DOT) com
<kel_way (AT) yahoo (DOT) com> wrote

Quote:

I realize that DTS isn't supported in 2005 Express. Is it possible to
use the DTS facility on an existing SQL Server 2000 installation in
order to push data to the Express installation? Many thanks -

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SQL Server 2005 Express DTS

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

SQL Server 2005 Express DTS - 05-22-2006 , 11:49 AM

Re: SQL Server 2005 Express DTS - 05-23-2006 , 07:57 AM