Format function in VB.net SSIS script

• nabajyoti.b

  SSCrazy

  Points: 2177

  More actions

  December 23, 2008 at 8:40 am

  #155048

  I was wondering if we culd generate date in yyyymmddhhnnss format

  in vb.net. However there is already a function vb

  Format(Now(), "YYYYMMDDhhnnss") which does not work in SSIS script.

  So, do we have an alternative to this?

• Jack Corbett

  SSC Guru

  Points: 184394

  More actions

  December 23, 2008 at 10:12 am

  #916891

  In .NET the preferred way to handle this is to use the ToSTring function with a Format specified. Like this:

  Now.ToString("yyyyMMddhhmmss")

  Jack Corbett
  Consultant - Straight Path Solutions
  Check out these links on how to get faster and more accurate answers:
  Forum Etiquette: How to post data/code on a forum to get the best help
  Need an Answer? Actually, No ... You Need a Question

• nabajyoti.b

  SSCrazy

  Points: 2177

  More actions

  December 24, 2008 at 3:54 am

  #917294

  Many Thanks.............