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


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.