<div>
thanks for your help. It definitely led me to the right solution
</div>


thanks for your help. It definitely led me to the right solution

<div>
Thank you, and trust it will all work well for you...
</div>


Thank you, and trust it will all work well for you...

<div>
<div class="content wysiwyg-content">
I am currently working with SQL Server 2005 and I want to use the BCP Utility to generate reporting information which is processed by another application. The output of the file takes the form of a pipe delimited csv file. The question that I have is how do I include the table columns as part of the report output? Is there a way to do this so that both the columns and the associated data are displayed in the .csv file?<br />
<br />
i.e column1 | column2 | column3 | ....<br />
&nbsp; &nbsp; &nbsp;data1 &nbsp; &nbsp; | data2 &nbsp; &nbsp; | data3 | ...<br />

</div>
</div>


I am currently working with SQL Server 2005 and I want to use the BCP Utility to generate reporting information which is processed by another application. The output of the file takes the form of a pipe delimited csv file. The question that I have is how do I include the table columns as part of the report output? Is there a way to do this so that both the columns and the associated data are displayed in the .csv file?

i.e column1 | column2 | column3 | ....
     data1     | data2     | data3 | ...


Using BCP utility in SQL Server 2005 for generating reports

Microsoft SQL Server 2005 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. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.