Writing to a file from a stored procedure using DTS

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by Zach Nichter » Writing to a file from a stored procedure...

Writing to a file from a stored procedure using DTS

Rate Topic

Display Mode

Topic Options

Author

Message

drifter

Posted Thursday, November 29, 2007 5:46 PM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, June 30, 2010 2:56 PM
Points: 3, Visits: 27

I have an audit store procedure which spits out the results from some select statements. now i need to find a way to write those results to a text file. Any ideas or help will be greatly appreciated. And if i can do it in DTS using a data pump that will be awesome.Thanks in advance

Post #427856

Jeff Moden

Posted Thursday, November 29, 2007 8:56 PM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 7:36 PM
Points: 32,931, Visits: 26,820

You might have a bit more luck getting a response to your posted this in the "Data Transformation Services" forum...

--Jeff Moden

"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Post #427896

« Prev Topic | Next Topic »

Permissions