Using BIDS 2008, export to flat file, can we give unique name for the file?

• wewe_halim

  Grasshopper

  Points: 11

  More actions

  January 27, 2011 at 6:36 pm

  #388724

  I am using BIDS 2008 to export to flat file(CSV)

  it will be automatically exported at 11.00 am in the morning.

  What i want to know, can we make it so the file that are being exported has a unique name each time it was being generated?

  so each day, the file will be generated with different date in the file name..

  for example:

  filename 28/01/11

  filename 29/01/11

  filename 30/01/11

  THANKS

• Lynn Pettis

  SSC Guru

  Points: 442467

  More actions

  January 27, 2011 at 6:59 pm

  #1279475

  Duplicate post, please post all replies here.

  Please, do not cross post as it simply fragments any responses you may get, and people may duplicate others answers.