Improve perfomance-Transfer data one table to another

[amardesai2005]

I would like to improve the perfomance in DTS package.

Here is the detail what i am trying to do

I have table called ProductNames which has more then
47000000 rows. I want to create DTS package which transfer all this rows to another table called productnames which is on another server.

It's taking so long to complete the job and i allready tried DataPump task & Copy SQL Server Objects task.
(Some time it never complete)

But I would like to use faster way.

Please let me know if anybody has better idia or solution

Any help would really appriciate.
AD

 

[MDXer]

Dump the records to a csv file and then import them into your destination.

Shoot Me! Shoot Me NOW!!!
- Daffy Duck

 

[amardesai2005]

You mean dump it in to csv file and then use bulk insert

Could you explain me in detail.
Thanks

AD

 

[amardesai2005]

How do i dump into csv ? I did some research and i found bulk insert it's fastest way to import the data.

So, Could you please help me out to write sql which dump sql table data into csv.

Thanks
AD