DTS export with dynamic filename..?

• Martin Larsson

  SSC Enthusiast

  Points: 126

  More actions

  April 1, 2008 at 10:50 am

  #204987

  Hi!

  I've searched for a solution to this problem all over and found numreous solutions, but I can't seem to get this one to work!

  What I want to do is to export a view to file (.xls) via DTS with dynamic filename.

  * The view contains 8 columns if that is of importance

  * The filename should be "Lev_YearWeek.xls"

  Normally I use the DTS Import/Export Wizard to do this, but if you suggest any other way I'm open...

  If you need any more info, please shout...

  Thanks in advance

  /Martin

• Lester Policarpio

  SSCertifiable

  Points: 7109

  More actions

  April 4, 2008 at 3:34 am

  #798283

  You can use sql "OPENROWSET" that is what im using and i can easily generate an excel file (report) with dynamic name on it example lester_yyyymmdd.xls try reading this good article

  http://www.simple-talk.com/sql/t-sql-programming/sql-server-excel-workbench/

  "-=Still Learning=-"

  Lester Policarpio

• Martin Larsson

  SSC Enthusiast

  Points: 126

  More actions

  April 4, 2008 at 6:41 am

  #798378

  I think I'm in love with you...

  Thank's a lot!!! :satisfied: