find out excel file modified date

• nitin.lokhande

  Old Hand

  Points: 317

  More actions

  June 27, 2012 at 5:35 am

  #271759

  Hello Friends

  I need to find out excel filet modified date. my task is that based on modification date = todaydate then i have to execute the task.

  i am using SSIS scripting and mail notifications.

  Thanks in advance

  Nitin

• kiril.lazarov.77

  Hall of Fame

  Points: 3742

  More actions

  July 18, 2012 at 3:32 am

  #1514088

  nitin.lokhande (6/27/2012)

  ---

  Hello Friends

  I need to find out excel filet modified date. my task is that based on modification date = todaydate then i have to execute the task.

  i am using SSIS scripting and mail notifications.

  Thanks in advance

  Nitin

  Hi,

  Only one file?

  I would use the execute process task in the control flow that calls a simple powershell script something like this.

  $d1 = Get-date

  $filepath = Get-ChildItem C:\files\whatever.xls

  $d2 = (Get-ItemProperty -Path $filepath).Lastwritetime

  if($d1.date -eq $d2.date)

  {Exit 0}

  else

  {Exit 999}

  Based on the exit codes you can preceed eg. if it is 0 then success precedence constraint otherwise failure.

• Sergiy

  SSC Guru

  Points: 110206

  More actions

  August 9, 2012 at 7:32 pm

  #1524170

  DECLARE @PathFile nvarchar(256)

  CREATE TABLE #FileDetails (

  [Alrernate Name] sysname NULL,

  [Size] bigint,

  [Creation Date] char(8),

  [Creation Time] char(6),

  [Last Written Date] char(8),

  [Last Written Time] char(6),

  [Last Accessed Date] char(8),

  [Last Accessed Time] char(6),

  [Attributes] int NULL

  )

  INSERT INTO #FileDetails

  exec master..xp_getfiledetails @PathFile

  _____________
  Code for TallyGenerator