title: SSIS Populating Date Time Format: "hh mm ss nnn cc yy mm dd"
body: <p>This is probably a pretty simple issue but:</p>
  
  <p>I'm trying to name a file TestSheet.hhmmssnnnccyymmdd  </p>
  
  <p>I set up a variable in SSIS and my expression in the expression builder is set up as :</p>
  
  <p><code>@[User::str_Var] + 
  Right("0" + (DT_STR,4,1252) DatePart("hh",getdate()),2) +
  Right("0" + (DT_STR,4,1252) DatePart("mi",getdate()),2) + 
  Right("0" + (DT_STR,4,1252) DatePart("ss",getdate()),2) + ".txt"</code></p>
  
  <p>and I know :</p>
  
  <p><code>Right("0" + (DT_STR,4,1252) DatePart("m",getdate()),2) +
  Right("0" + (DT_STR,4,1252) DatePart("d",getdate()),2)</code></p>
  
  <p>Will get me "mm" and dd" </p>
  
  <p>My question is.. I have "hh mm ss mm dd", how do I get "nnnccyy"?</p>