Using SQLCMD Utility for Query Resultset Data Export as a File

This video is part of a SSIS Project - "Generate Extracts based on queries of a table".
In this video, you will learn how to use SQLCMD SQL Server Command line Utility to export query result as a text file.
Please follow the playlist in a sequential order to under stand the project better.
Thanks!

[ARCI]

Thank you very much for the tutorial :) keep it up please thank you. subscribed already

[borbetomagus]

Thanks for your video. A possibly easier method to remove the second line (and keep existing column headers, if there are numerous ones) would be to use a subsequent SED command, which is available from CygWin64 and GnuWin32, then move the results upon the original path:
SED 2d 'current file path and name' > 'revised file path and name' & move /y 'revised file path and name' 'current file path and name'

Or better yet, just append the following at the very end of the SQLCMD command (after the 'localhost' options):
&& SED -i 2d 'current file path and name'

[krubioc]

English is not my native language. When I run the batch, the information is only displayed in one column in my csv file and not in different ones like in your case. Could you help me?

[dianatorrontegui]

Hi, great tutorial, I would like to know if I can use this command to export in .xlsx format. Thanks

[hasanmosharrof]

instead of using sqlcmd you can also select the whole output and save as csv in your local machine. both serves the same purpose

[alextomislav]

Nice post, is there way to delete the file using sqlcmd without using xp_cmdshell? Please share the link if you know about it