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:38 pm

  #234206

  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

• mateusz b

  SSC Enthusiast

  Points: 147

  More actions

  January 28, 2011 at 1:04 pm

  #1279905

  Use sql script task to generate variable and then use it like a filename.

• Koen Verbeeck

  SSC Guru

  Points: 259197

  More actions

  January 29, 2011 at 6:00 am

  #1280063

  mateusz.bazan (1/28/2011)

  ---

  Use sql script task to generate variable and then use it like a filename.

  Do you mean a Script Task, or an Execute SQL Task?

  But why make it difficult? The solution can quite easily be obtained by property expressions, as stewartc already suggested.

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP