Right click your log file connection, click on properties

In the property windows click on Expressions > ConnectionString

image

 

Expression

Add the expression:

(DT_WSTR,1000)
(
  "C:\Temp\" +
  RIGHT("0" + (DT_STR,4,1252) DATEPART("year",GETDATE()),4) +
  RIGHT("0" + (DT_STR,2,1252) DATEPART("month",GETDATE()),2) +
  RIGHT("0" + (DT_STR,2,1252) DATEPART("day",GETDATE()),2) +
  RIGHT("0" + (DT_STR,2,1252) DATEPART("hour",GETDATE()),2) +
  RIGHT("0" + (DT_STR,2,1252) DATEPART("minute",GETDATE()),2) +
  RIGHT("0" + (DT_STR,2,1252) DATEPART("second",GETDATE()),2) +
  ".log"
)

 

Result

Result will be: C:\Temp\20101126121212.log

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.