<div>
<div class="content wysiwyg-content">
How to execute bcp (which calls xp_cmdshell using the SQLAgentCmdExec id) from within a stored procedure and copy data into an Excel file on a file server? &nbsp;Does SQLAgentCmdExec need rights to the location on the file server?
</div>
</div>


How to execute bcp (which calls xp_cmdshell using the SQLAgentCmdExec id) from within a stored procedure and copy data into an Excel file on a file server?  Does SQLAgentCmdExec need rights to the location on the file server?

How can we place a file in a particular location on a server

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.