<div>
I would probably do this with a powershell script. &nbsp;I don't have a sample with me right now but we do this all the time at work to automate exports from sql to csv and/or email. &nbsp;Once you're done with the script you can execute it from a simple .bat file and schedule the .bat to run whenever you want from the normal windows task scheduler.<br />
<br />
Found this with a quick search, may help get you started if you want to give it a shot:<br />
<a href="http://beyondrelational.com/modules/2/blogs/908/posts/18005/exporting-from-sql-server-to-csv-file-using-powershell.aspx" rel="ugc">http://beyondrelational.co<wbr />m/modules/<wbr />2/blogs/90<wbr />8/posts/18<wbr />005/export<wbr />ing-from-s<wbr />ql-server-<wbr />to-csv-fil<wbr />e-using-po<wbr />wershell.a<wbr />spx</a>
</div>


<div>
I really appreciate Vito Montalvao he really taught me a few things doing this effort.
</div>


<div>
<div class="content wysiwyg-content">
I am really struggling trying to automate a script to export a sql server table into a cvs file that can sorted and put in a shared folder. &nbsp;I have try the export tool in sql server but can't find a way to sort the file. &nbsp;I also try to BCP the file in to a cvs file and couldn't get that to work. &nbsp;I know that this can be done. &nbsp;Please advised.
</div>
</div>


I am really struggling trying to automate a script to export a sql server table into a cvs file that can sorted and put in a shared folder.  I have try the export tool in sql server but can't find a way to sort the file.  I also try to BCP the file in to a cvs file and couldn't get that to work.  I know that this can be done.  Please advised.

How to export a csv comma delimited sorted file using SQL Server?

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

SQL Server Integration Services (SSIS) is a component of the Microsoft SQL Server database software that can be used to perform a broad range of data migration tasks. SSIS is a platform for data integration and workflow applications. It features a fast and flexible data warehousing tool used for data extraction, transformation, and loading (ETL). The tool may also be used to automate maintenance of SQL Server databases and updates to multidimensional cube data. SSIS replaced Data Transformation Services, which had been a feature of SQL Server since Version 7.0.