UNC Path drive space

• mtz676

  SSCrazy Eights

  Points: 9214

  More actions

  October 13, 2016 at 12:08 am

  #330918

  Can I get the total drive space and free space from a UNC path using SSIS

  1. \\abcd - Total drive space and available drive space

  2.\\abcd\defg - Total drive space and available drive space

  In case the available drive space falls below 30% I would like to be informed via email.

  Is this possible using SSIS

  Thanks

• PB_BI

  SSCoach

  Points: 17463

  More actions

  October 13, 2016 at 6:54 am

  #1906306

  The following should help you:

  https://www.mssqltips.com/sqlservertip/2932/using-the-ssis-wmi-task-to-gather-system-information/

  Just output the values you need (free space, total space) to variables, have a third variable which calculates percentage left and then use precedent constraints to either alert you or do nothing.

  ---

  I'm on LinkedIn