Unique Naming Convention

• TriggerMe

  SSChampion

  Points: 11752

  More actions

  August 5, 2008 at 7:36 pm

  #125491

  I have a package that has simple data flow task. The data flow task has an ole db connection to a SQl

  2005 database and it executes a query that then flows to a csv file to a location.

  The package will be executed many times overwriting the same file output.

  My question is, how can you name the ouput file with a unique naming convention so that we

  keep a history of each output. Example, I wish to name my output file Customer_30062008_v1.csv

  ---

  Kindest Regards,

• KenpoDBA

  SSCrazy Eights

  Points: 9811

  More actions

  August 5, 2008 at 10:16 pm

  #853614

  Well, the easiest way is to use the date/time in the filename.

  Will that work for you?

  Watch my free SQL Server Tutorials at:
  http://MidnightDBA.com
  Blog Author of:
  DBA Rant – http://www.MidnightDBA.com/DBARant

  Minion Maintenance is FREE: