load sql server table data to flat file with out applications

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » T-SQL » load sql server table data to flat file with...

load sql server table data to flat file with out applications

Rate Topic

Display Mode

Topic Options

Author

Message

viveksvkola

Posted Tuesday, September 25, 2012 4:03 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, May 09, 2013 10:37 AM
Points: 144, Visits: 75

Hi,

This is vivek, i have one requirement load sql server table data to flat file(text file) with out applications.please any one help to me.

Thanks&Regards,
vivek. Smile

Post #1363905

laurie-789651

Posted Tuesday, September 25, 2012 4:52 AM

SSC Veteran

Group: General Forum Members
Last Login: Today @ 8:56 AM
Points: 274, Visits: 787

If your table is not very big, you could SELECT * FROM Table using 'Results to Text' instead of grid, then copy & paste the output to a text file. BigGrin

Post #1363940

vyas

Posted Tuesday, September 25, 2012 4:55 AM

Hall of Fame

Group: General Forum Members
Last Login: Thursday, May 16, 2013 4:02 AM
Points: 3,131, Visits: 1,056

You can use BCP

Post #1363942

anthony.green

Posted Tuesday, September 25, 2012 5:39 AM

SSCertifiable

Group: General Forum Members
Last Login: Friday, April 12, 2013 3:51 AM
Points: 5,075, Visits: 4,831

DTS is another one to use

Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger

Post #1363956

Lowell

Posted Tuesday, September 25, 2012 5:50 AM

SSChampion

Group: General Forum Members
Last Login: Today @ 9:36 AM
Points: 11,618, Visits: 27,680

unless you consider dbmail creating an attachment as a file for an email, SQL server itself, doesn't have any native ways to write files to disk that I can think of; everything's an application...SQL Server Management Studio itself,, bcp,dts/ssis, CLR methods, powershell, Office like excel/word, custom applicaitons, etc all would count as "applications" in my book.

it would be better for you to identify what applications you don't wnat to use instead.

what's the real requirement? write data to disk, or not use applications at all? Think it through and let us know what you really need to do.

Lowell

--There is no spoon, and there's no default ORDER BY in sql server either.
Actually, Common Sense is so rare, it should be considered a Superpower. --my son

Post #1363958

viveksvkola

Posted Tuesday, September 25, 2012 7:21 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, May 09, 2013 10:37 AM
Points: 144, Visits: 75

table is very big Smile

Post #1364026

lptech

Posted Tuesday, September 25, 2012 8:04 AM

SSC Journeyman

Group: General Forum Members
Last Login: Yesterday @ 2:16 PM
Points: 96, Visits: 978

You can try OPENROWSET, documented in Books Online.

Post #1364059

« Prev Topic | Next Topic »

Permissions