how to create new excel file with query every day

• s.salikupt

  SSC Rookie

  Points: 27

  More actions

  July 3, 2013 at 8:45 pm

  #296053

  I must create daily report and i must create new excel file each day with SSIS such as

  Today = Report1-04/07/2013.xls

  Tomorrow = Report0-05/07/2013.xls

  do you have a solution?

  sorry for my English Skill ^^

  Thnank you

• Koen Verbeeck

  SSC Guru

  Points: 259155

  More actions

  July 4, 2013 at 12:49 am

  #1629746

  You need to create an expression on the Excel connection manager.

  You can find an example in this article:

  SSIS: How to add a timestamp to a Excel File output path.[/url]

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP