Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Zach Nichter Writing to a File Using the sp_OACreate Stored Procedure and OSQL: The RE: Writing to a File Using the sp_OACreate Stored Procedure and OSQL: The

  • February 7, 2006 at 9:52 am

    #619337

    Yet another approach is to write to a table, then use sp_OA... stored procedure to create a BulkCopy object and "export" the table to a file. I got this method from K Henderson's Guru's Guide to SQL Server Stored Procedures... He includes a procedure, sp_ExportTable that performs this operation very quickly (using speed of BulkCopy) and avoids xp_cmdshell altogether. I am curious how its speed compares--might have to test it.