Automating excel generation ( with unique name)

• santhosh4u

  Newbie

  Points: 7

  More actions

  July 9, 2002 at 12:01 am

  #64177

  Iam using sqlserver7.0. I have to create an excel file of data extracted from a table in the database. This process should be automated and should be invoked every friday. I have created a job for this using DTS. I would like to give a unique naming convention for files generated everyweek.I would like to give the name as fileDDMMYY. How can we do this in a job. Is there any other menthod?. Could any one help me in sorting out this?. Thanks in advance

  Santhosh

• Steve Jones - SSC Editor

  SSC Guru

  Points: 738713

  More actions

  July 9, 2002 at 9:40 am

  #432265

  You could use DTS to either alter the package (hard) or generate a filename and rename the generated one (easier).

  Look for the filesystemobject on MSDN and that will point you in the right direction.

  Steve Jones

  sjones@sqlservercentral.com

  http://www.sqlservercentral.com/columnists/sjones