Creating a file from within stored procedure

Question

Post reply

Creating a file from within stored procedure

Jeff W

SSCertifiable

Points: 5207
More actions
April 7, 2004 at 3:59 pm

#86559

Without executing master..xp_cmdshell, does anyone have any suggestions on how to create a file from within a stored procedure? The file will be the results of a query dynamically created in the stored procedure.

Thanks,
Jeff

"Keep Your Stick On the Ice" ..Red Green

Viewing 8 posts - 1 through 7 (of 7 total)

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

Frank Kalis SSC Guru Points: 111183 More actions · Answer 1

One thing that comes to mind are the sp_OA* procedures. But they certainly have a huge downside.

What about doing this at the client?

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

DKC Old Hand Points: 325 More actions · Answer 2

You could use an extended stored proc to write a file from within a stored proc, but this would probably be an overkill...

--

Jeff W SSCertifiable Points: 5207 More actions · Answer 3

Frank.........I've been offline for awhile with a job change. Good to see you lurking out here. The client is probably going to have to do this, but I have been sent on a quest to see if there is a way to execute a DTS package within a proc w/out using xp_cmdshell. I don't think there is and it is hard to prove a negative so I generalized my question and posted.

Diwakar....I thought about the extended stored proc after I posted and your probably right about the overkill. I'm not sure of the skillset of the people working on this application either. It may confuse them even more.

I'll check up on the sp_OA...s Not familiar with these.

Thanks All!!

"Keep Your Stick On the Ice" ..Red Green

akshay1974 SSC-Addicted Points: 444 More actions · Answer 4

Jeff,

How about creating a job without a schedule for the DTS and then start the job from within the procedure ?

robinhc SSCommitted Points: 1617 More actions · Answer 5

How about seting up a file has a linked server using a flat text file ODBC driver? OR something along those lines. Treat the file has a single column table and write to it.

Frank Kalis SSC Guru Points: 111183 More actions · Answer 6

Frank.........I've been offline for awhile with a job change. Good to see you lurking out here. The client is probably going to have to do this, but I have been sent on a quest to see if there is a way to execute a DTS package within a proc w/out using xp_cmdshell. I don't think there is and it is hard to prove a negative so I generalized my question and posted.

Hope everything's fine with the new job!

Just another thought. You might find something useful on here

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

DOMcCrea Grasshopper Points: 11 More actions · Answer 7

Consider using a WebTask (See sp_makewebtask, sp_runwebtask in BOL).

DOM