Export to flat file without using bcp or extended stored procedure

Question

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

HowardW One Orange Chip Points: 29109 More actions · Answer 1

You could create an SSIS package to export the data to a flat file.

To call it from a stored procedure without requiring cmdshell, you could add it as a SQL Agent job and start the job within the procedure.

Orlando Colamatteo SSC Guru Points: 182279 More actions · Answer 2

Unfortunately BULK EXPORT does not exist. Please vote for the suggestion here:

There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato

Ron McCullough SSC Guru Points: 63877 More actions · Answer 3

Have you tried OPENROWSET ? I know it works on 2005, but have as yet not tested on 2008

/*Text file must exist and have a first line of comma separated field names*/

INSERT INTO OPENROWSET('Microsoft.Jet.OLEDB.4.0',

'Text;Database=F:;HDR=Yes;', 'SELECT * FROM Test.txt')

SELECT * FROM Keywords

Sample of output from Test.txt

Keywordid, keyword

"1","Discs"

"2","freespace"

"3","drives"

"4","UTC"

Test.txt = existing file with comma seperated column names of my table

Keywords = my existing tables name

If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read[/url]
Before posting a performance problem please read[/url]