Showing posts with label thorugh. Show all posts
Showing posts with label thorugh. Show all posts

Monday, March 26, 2012

EXPORT Data From TXT FILE TO SQL SERVER

hi,

how can i export from sql sever table data to another text or csv file thorugh sql server stored procedure..import is working fine...

can u give me a solution ..

Thanks and Regards
ArulThere are ways to run though the File I/O in a stored procedure, but do you really want your sql server to have that type of file security abilities?

I'd suggest either doing through code, or running a loop that sets a file to become that text file. And blob that.

there's also DTS Capabilities that you can use.

Books Online is your best friend. Remember that.