Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Data Extraction

Author  Topic 

Sheetal
Starting Member

10 Posts

Posted - 2007-10-16 : 05:37:21
Hi Sir,

There are two ways to extract the source data from other Servers (Oracle or MS SQL).

1) DTS
2) SP

Please let me know which one is betterway to extract the data and why?

Regards,
Sheetal

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-10-16 : 06:09:17
As always, it depends on your business requirements.



E 12°55'05.25"
N 56°04'39.16"
Go to Top of Page
   

- Advertisement -