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)
 Exporting sql server data to csv file

Author  Topic 

sachingovekar
Posting Yak Master

101 Posts

Posted - 2009-10-26 : 13:02:24
Hi,

I want to export millions of records from sql server table to csv file.
I noticed rows getting overlaped.
What can be the best strategy to import.
I am directly exporting from Microsoft SQL SERVER 2005 MANAGEMENT STUDIO.

Kindly help.
Regards,
Sachin

mfemenel
Professor Frink

1421 Posts

Posted - 2009-10-26 : 13:18:32
Could you explain what you mean by "getting overlapped"? Post an example maybe?

Mike
"oh, that monkey is going to pay"
Go to Top of Page

sachingovekar
Posting Yak Master

101 Posts

Posted - 2009-10-27 : 00:23:33
for eg:


username city department address
adam igeo texas finance 606, street,


igeo is a surname and texas is department
Go to Top of Page
   

- Advertisement -