<div>
Use BCP<br />
Create a folder and place the file there.<br />
Use Database mail to send mail with attachment. Below the reference<br />
<br />
<a href="http://blogs.msdn.com/b/sqlagent/archive/2010/11/10/sql-database-mail-send-emails-with-attachment.aspx" rel="ugc">http://blogs.msdn.com/b/sqlagent/archive/2010/11/10/sql-database-mail-send-emails-with-attachment.aspx</a><br />
<br />
Use a batch file to achieve the above steps. And schedule the batch file if needed. <br />
<br />
Note; Use SQLCMD.exe to run sql scripts inside batch file.
</div>


Use BCP
Create a folder and place the file there.
Use Database mail to send mail with attachment. Below the reference

http://blogs.msdn.com/b/sqlagent/archive/2010/11/10/sql-database-mail-send-emails-with-attachment.aspx [http://blogs.msdn.com/b/sqlagent/archive/2010/11/10/sql-database-mail-send-emails-with-attachment.aspx]

Use a batch file to achieve the above steps. And schedule the batch file if needed.

Note; Use SQLCMD.exe to run sql scripts inside batch file.

<div>
Hi,<br />
<br />
Export data using the &quot;BCP&quot; and send mail using db_sendmail SP.<br />
<br />
else<br />
<br />
best way to Create SSIS packages.<br />

</div>


Hi,

Export data using the "BCP" and send mail using db_sendmail SP.

else

best way to Create SSIS packages.


<div>
<div class="content wysiwyg-content">
I have to generate a report using two tables in SQL server 2008 and send it in CSV format to recipients.<br />
&nbsp;I have already written the query(Thats Okay) . How can I use reporting services ,SSRS to do this automatically . That is send the CSV file to email automatically everyday.<br />
or SSIS or what other process can I use to do this and automate the whole process to go everyday.<br />
<br />
Pls can you outline the steps very well and processes I should use.if there are little code involved too, pls let me have it.<br />
<br />

</div>
</div>


I have to generate a report using two tables in SQL server 2008 and send it in CSV format to recipients.
 I have already written the query(Thats Okay) . How can I use reporting services ,SSRS to do this automatically . That is send the CSV file to email automatically everyday.
or SSIS or what other process can I use to do this and automate the whole process to go everyday.

Pls can you outline the steps very well and processes I should use.if there are little code involved too, pls let me have it.



How to Generate CSV file from SQL server tables and send it by email  to recipients in an automated process

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 Reporting Services (SSRS) is a server-based report generation software system from Microsoft. It can prepare and deliver a variety of interactive and printed reports and is administered via a web interface or its web service. Its web services interface also supports the development of custom reporting applications. Finally, SSRS can also be integrated with SharePoint. SSRS competes with other business intelligence tools, most prominently Crystal Reports.

SSRS

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.