dont wan to overwrite excel template at destination

• dallas13

  SSCertifiable

  Points: 7491

  More actions

  November 25, 2008 at 12:37 pm

  #215682

  I am using one ssis package and source =sql server i m getting some data

  from sql database by writing a query and i need to load that results to excel destination.

  my manager wants me to use excel template in which i need to load results

  i m using file system task to copy that template from one place to another

  i want this package to run daily(automatic)and i want to create new excel file everyday

  so for file system task

  for my source i m configuring a variable named "source_template"=C:\abc\text_template.xls

  destination = C:\ abc\taxes\test.xls

  this is not possible daily because my destination has already test file exists

  what should i do, how to configure this destination variable so that it will be in this format

  like test_2008_11_25.xls??

  so ultimately i want new file created everyday with datestamp.

  can anyone tell me how to configure this variable??

  Thanks a lot

• Tim Mitchell

  SSCoach

  Points: 15685

  More actions

  November 25, 2008 at 2:11 pm

  #903431

  You could use a script task to create your filename as a variable based on the date.

  hth,

  Tim

  Tim Mitchell
  TimMitchell.net | @tmitch.net | Tyleris.com
  ETL Best Practices