SQL Server Performance

Urgent Generate Access Database and Excel sheet

Discussion in 'SQL Server DTS-Related Questions' started by GAR, Oct 3, 2007.

  1. GAR New Member

    hi
    I need to run update queries on a database and generate an access database and an excel file and finally call WINRAR to zip both files with the name as follows..
    Sortie_with_Current_date
    eg Sortie_4 July 2007
    Means system Date
    thanks in advance
  2. Adriaan New Member

    Just take one step at a time.
    (1) Run the update queries (lookup UPDATE in Books Online).
    (2) Export data to MDB and XLS formats (lookup Data Transformation Services).
    (3) Do a command line call for WinRAR (lookup xp_cmdshell).

Share This Page