Storing Files Created Date

• Scott L. Moore

  Old Hand

  Points: 339

  More actions

  June 21, 2007 at 8:45 am

  #120435

  Hi,

   

  I need help in SSIS, i need to store the creation date of a text file as a variable but i dont know how.

   

  Any suggestions?

   

  Many thanks

   

  Scotty

• Crispin Proctor

  SSCoach

  Points: 18161

  More actions

  June 26, 2007 at 4:09 am

  #715157

  You'll have to use a script task and get the file attributes in there. Once got, you can assign them to a SSIS variable.

  See google for getting file attributes in VB.net.

  Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!