Posted By

michanne on 12/23/10


Tagged

Microsoft SSIS integrationservices


Versions (?)

SSIS Log File Name


 / Published in: Other
 

Basic Datetime format based on Package name. MyPackage20101222-1316_34.log.xml

  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  

You need to login to post a comment.