how to move data/objects faster with DTS

#1

Is it faster to move data between 2 tables using DTS or more of an insert
<newtable> select * from <table>

I would like to use DTS but it appears very slow. Is there any setting to
make it faster ? Using the generic wizard to export data

#2

Hi Hassan,

You can turn off the logging, by selecting simple recovery mode, till you
finish copying. Also you can think of disabling the index on the destination
table, while moving the data.

--
- - - - - - - - -
Thanks
Yogish

"Hassan" wrote:

Quote:

Is it faster to move data between 2 tables using DTS or more of an insert
newtable> select * from <table

I would like to use DTS but it appears very slow. Is there any setting to
make it faster ? Using the generic wizard to export data

#3

Also refer the following article for more details
http://www.mssqlcity.com/Tips/bulk_c...timization.htm

--
- - - - - - - - -
Thanks
Yogish

"Hassan" wrote:

Quote:

Is it faster to move data between 2 tables using DTS or more of an insert
newtable> select * from <table

I would like to use DTS but it appears very slow. Is there any setting to
make it faster ? Using the generic wizard to export data

#4

Hi,

Use the BULK INSERT task in DTS package. Bulk insert is faster.

Thanks
Hari
SQL Server MVP

"Hassan" <fatima_ja (AT) hotmail (DOT) com> wrote

Quote:

Is it faster to move data between 2 tables using DTS or more of an insert
newtable> select * from <table

I would like to use DTS but it appears very slow. Is there any setting to
make it faster ? Using the generic wizard to export data

#5

isnt Bulk insert sources data from a file into SQL ?

My source and destination is SQL Server tables and are local too.

"Hari Prasad" <hari_prasad_k (AT) hotmail (DOT) com> wrote

Quote:

Hi,

Use the BULK INSERT task in DTS package. Bulk insert is faster.

Thanks
Hari
SQL Server MVP

"Hassan" <fatima_ja (AT) hotmail (DOT) com> wrote in message
news:esYPJCZkFHA.1372 (AT) TK2MSFTNGP10 (DOT) phx.gbl...
Is it faster to move data between 2 tables using DTS or more of an
insert
newtable> select * from <table

I would like to use DTS but it appears very slow. Is there any setting
to
make it faster ? Using the generic wizard to export data

#6

What he probably meant was, BCP OUT to a file and then use BULK INSERT to a
target table.

--
- - - - - - - - -
Thanks
Yogish

"Hassan" wrote:

Quote:

isnt Bulk insert sources data from a file into SQL ?

My source and destination is SQL Server tables and are local too.

"Hari Prasad" <hari_prasad_k (AT) hotmail (DOT) com> wrote in message
news:%23Mf4ThakFHA.3288 (AT) TK2MSFTNGP10 (DOT) phx.gbl...
Hi,

Use the BULK INSERT task in DTS package. Bulk insert is faster.

Thanks
Hari
SQL Server MVP

"Hassan" <fatima_ja (AT) hotmail (DOT) com> wrote in message
news:esYPJCZkFHA.1372 (AT) TK2MSFTNGP10 (DOT) phx.gbl...
Is it faster to move data between 2 tables using DTS or more of an
insert
newtable> select * from <table

I would like to use DTS but it appears very slow. Is there any setting
to
make it faster ? Using the generic wizard to export data

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

how to move data/objects faster with DTS

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

how to move data/objects faster with DTS - 07-25-2005 , 10:17 PM

RE: how to move data/objects faster with DTS - 07-25-2005 , 11:16 PM

RE: how to move data/objects faster with DTS - 07-25-2005 , 11:21 PM

Re: how to move data/objects faster with DTS - 07-26-2005 , 01:06 AM

Re: how to move data/objects faster with DTS - 07-26-2005 , 02:11 AM

Re: how to move data/objects faster with DTS - 07-26-2005 , 03:14 AM