Export the Data from Sql to Excel sheet used DTS

[thangsan]

Hi Friends,

In my project i need to Export the Data from Sql server to Excel Sheet.
It should be auto schedulder certain intervals(months). i want to store the Excel sheet in .CSV format to the Particular Location. Before store the Data it should be checked whether the fils is exist or not. These all the things should be happen in Sqlserver side without using any UI( Asp or asp. net or VB).
Please send me the query or Steps to acheive or SP)


Regards.
sankar P T

[Jim Doherty]

Hi Friends,

In my project i need to Export the Data from Sql server to Excel Sheet.
It should be auto schedulder certain intervals(months). i want to store the Excel sheet in .CSV format to the Particular Location. Before store the Data it should be checked whether the fils is exist or not. These all the things should be happen in Sqlserver side without using any UI( Asp or asp. net or VB).
Please send me the query or Steps to acheive or SP)


Regards.
sankar P T

One simple method for you to look at as an alternative which you might want to schedule as a job as part of a sproc if it helps

sp_makewebtask @outputfile = 'c:\yourfilename.csv', 
  @query = 'Select * from yourqueryname', 
  @colheaders =1, 
    @FixedFont=0,@lastupdated=0,@resultstitle='Title for your ProjectData', 
  @dbname ='YourSQLServerDatabasename' 

[azimmer]

Hi Friends,

In my project i need to Export the Data from Sql server to Excel Sheet.
It should be auto schedulder certain intervals(months). i want to store the Excel sheet in .CSV format to the Particular Location. Before store the Data it should be checked whether the fils is exist or not. These all the things should be happen in Sqlserver side without using any UI( Asp or asp. net or VB).
Please send me the query or Steps to acheive or SP)


Regards.
sankar P T

Create an export package with the DTS Import/Export Wizard and at the end save and schedule it for periodic execution. The wizard is straightforward to use but should you need assistance this is a beginner's step-by-step guide: http://articles.techrepublic.com.com/5100-1035_11-1043668.html