Export data from sql server to a text file

Question

Hi I want to know that Which utilities can we used to export data from sql server to a text file?

Jignesh Trivedi · Answer

hi there are many way to export data. and many 3rd party tool is alco avalable. but simplest way is use BCP command. EXEC xp_cmdshell 'bcp SELECT * FROM sysObject queryout C:\mybcptest.txt -T -c -t' please refer http://www.mssqltips.com/sqlservertip/1633/simple-way-to-export-sql-server-data-to-text-files/ http://msdn.microsoft.com/en-us/library/ms162802.aspx hope this help.

Ravindra T C · Answer

Hi Deepak First create one empty textfile use Data Transformation Services (DTS) tools to export the data from table to textfile select datasource SQL Server Native Cleint 10.0 and server name is your server name then select the database. Destination select Flat File Destination for textfile then browse and select that empty textfile click next and finish all the data will be loaded into your textfile. Thanks Ravindra T C Software Engineer Marlabs Software Pvt Ltd.