Advanced Search

SSIS Log File Name

/ Published in: Other
Save to your folder(s)
Basic Datetime format based on Package name.
MyPackage_20101222-13_16_34.log.xml

Expand | Embed | Plain Text

Copy this code and paste it in your HTML 
  1. @[System::PackageName] +"_" + (DT_STR, 4,1252) year( @[System::ContainerStartTime] ) + (DT_STR, 2,1252) month( @[System::ContainerStartTime] ) + (DT_STR, 2,1252) day( @[System::ContainerStartTime] ) + "-"+(DT_STR, 2,1252)  DATEPART(  "hh",@[System::ContainerStartTime] ) + "_" + (DT_STR, 2,1252) DATEPART(  "mi",@[System::ContainerStartTime] ) +"_" + (DT_STR, 2,1252)  DATEPART(  "s",@[System::ContainerStartTime] ) + ".log.xml"

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.