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 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Importing File

Author  Topic 

dewacorp.alliances

452 Posts

Posted - 2008-02-25 : 14:37:51
Hi there

What is your opinion if you want to create a simple .net interface that do the upload file, message data and produce the output file? I've done through dts api stuff but how about bcp?

Or is there any other methods considering 500,000+ data upload.

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-02-25 : 14:46:20
BULK INSERT is reasonably fast too.



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

- Advertisement -