Using Variable Values in Excel Destn Filenames to dynamically create Excel Files

• sql_learner29

  SSCrazy Eights

  Points: 9107

  More actions

  June 19, 2008 at 12:14 pm

  #122824

  Hi All,

  I have a problem, I want to create several 100 reports from one table that should go into seperate excel files..

  now I need to find a way to create Excel files Dynamically with changing date in there...

  Like

  D:\Tempfolder\Report_on_@startdatevalue...

  Pls tell me if you know...how to create dynamically excel files from same table with names having a variablevalue in it..

  Regards

  Thanks in advance

  [font="Comic Sans MS"]
  ---------------------------------------------------

  Thanks [/font]

• pduplessis-723389

  SSChampion

  Points: 10599

  More actions

  June 20, 2008 at 1:41 am

  #831545

  On your connectionmanager, look at the expressions section.

  Add an expression and change the connectionstring property to your variable.

  TADA

  ~PD

• iskarta

  SSC Enthusiast

  Points: 139

  More actions

  June 20, 2008 at 2:34 am

  #831572

  I think you can use the Script Task component.

  At first you must define a variable @x

  After that you can set it in the Script Task component.

  Dts.Variables("x").Value= "D:\Tempfolder\Report_on_" + @startdatevalue

  as a next job;

  when you define Excel File connection Manager , Point varible x.

  I'm sure it works because I use this method.