Post reply

Turning query output into csv file automatically

  • January 18, 2005 at 4:50 am

    #68034

    I have around 20 queries that run each week (in SQL Query Analyser) and each of these queries creates a table which I currently have to manually save to my PC as a csv.  Is there a way I can run the query automatically so that it automatically creates a csv file.  Better still, is there a way that I can run all 20 queries with one batch job to create all 20 tables. 

    The csv table names remain the same.

    I am new to SQL Server and know this is possible but don't know how!

     

  • January 18, 2005 at 5:35 am

    #537805

    A scheduled DTS package should do this for you - it can be designed to create all 20 csv files, one after another and run automatically every week. As you're new to SQL Server, your knowledge of DTS is maybe a little thin also. Try looking on http://www.sqldts.com for a kick start.

    Regards

    Phil

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply