SQL Engine - BULK EXPORT command - by SQLJack

Status : 

  Won't Fix<br /><br />
		Due to several factors the product team decided to focus its efforts on other items.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.

Sign in
to vote
ID 224026 Comments
Status Resolved Workarounds
Type Suggestion Repros 7
Opened 10/11/2006 11:39:55 AM
Duplicates 512367 Access Restriction Public


There is no simple means to output data to the filesystem from within a stored procedure or sql script.
Sign in to post a comment.
Posted by SQLJack on 9/21/2017 at 7:34 AM
Hi SQL Team -
How about reconsidering this suggestion for an upcoming release of SQL Server
Posted by Stevepmo on 12/21/2016 at 3:25 AM
No sign of it in SQL vNext either. But this feature has been requested for a very long time. Yesterday I read a blog comparing PostgresSQL to SQL Server and one of the many reasons the review thought Postgres was better was because of better CSV support. Bulk Import is getting some love can we get even a simple implementation of Bulk Export please.
Posted by Jeff Moden on 5/21/2014 at 6:13 AM
Sunil of Microsoft wrote:
"we are faced with the challenges of customer ASKs"
"Customer ASKs"???? What's that and how do we get on THAT list?

Would you good folks reconsider this wonderful and very needed change if I made is so the number of upvotes on this change doubled?
Posted by SQLJack on 1/8/2014 at 6:59 AM
Resolved as "Won't Fix" is disappointing at best - there are many valid use cases for this feature, can we get the suggestion re-opened and considered for a future release?
Posted by Bappy on 6/28/2012 at 3:38 AM
'Resolved' ?

refusing to do something isn't the same as 'Resolved'.. Can I suggest you change this text from 'Resolved' to "Tough buns"? :D

Can you pleae advise if this will be considered again in the next version of SQL Server (whats that going to be SQL Server 2014?) as like Orlando said, the only way around this is to open up the use of xp_CmdShell which is insecure and against microsoft's own recommended best practices. SSIS is a capable product and has it's place but it is NOT the perfect solution to every single ETL task like microsoft's developers seem to think it is.

In my experience as an IT professional, 9 times out of 10 the simplest solution is going to be the best solution. Using a massive ETL package like SSIS to simply dump a table to flat file is most certainly not a simple solution.

That's my 2p anyway :)
Posted by opc.three on 6/17/2012 at 2:18 PM
The closure of this item as "Won't fix" leaves developers that want or need to keep all their code in T-SQL to enable xp_cmdshell and use either bcp or SSIS to get data from table to disk. Or possibly use the SQLCLR in some creative way. In any event, the lack of a native T-SQL method is a glaring hole in T-SQL. It would be nice to start closing the security loops we are compelled to open to do basic things like writing data from a table to disk. I for one am disappointed in the resolution of this item.

Posted by Microsoft on 12/20/2011 at 12:09 PM
In any release, we are faced with the challenges of customer ASKs and match those with the resources and the available time. Unfortunately, there will be no support for Bulk Export in SQL 2012.

Posted by Jeff Moden on 10/13/2011 at 6:17 PM
And here we are, just several months away from yet another release of SQL Server and, unless I missed something, there's no sign of such an improvement as "BULK EXPORT". If I asked for a "suite" of file handlers available through T-SQL, would that be cause for quicker action and more promising action? ;-)
Posted by Jeff Moden on 2/13/2011 at 8:55 AM
Hi Micorsoft...

What would really be cool is if you considered it for a retro-active backfit of SQL Server 2005 and up.
Posted by SQLJack on 9/22/2010 at 11:13 AM
Almost 4 years since I suggested this and 3 since it was deemed useful - any thoughts if this may make it into the 2011 release?
Posted by Microsoft on 1/28/2010 at 9:12 AM
I agree with your points.

Posted by Doron_F on 12/31/2009 at 12:18 PM
I also can appreciate the BULK EXPORT. Right now bigger files are cut and the file become useless.
So this way the entire sql statement plus the export process SCRIPT is all encapsulated in one SP one place and one technology.

Also this way the entire process is done locally on the server and thus minimize any security issue.
Posted by Microsoft on 9/27/2007 at 1:41 PM
This is a useful suggestion. We will consider this in the future release.