load xls file to sql

• Jeffrey Williams

  SSC Guru

  Points: 89745

  More actions

  July 12, 2021 at 4:14 pm

  #3907057

  So what problems are you having adding the additional steps?  Pretty simple to add a copy/move step to backup (archive) the file - and getting the count of rows in a CSV file is simply $csv.Count.

  Jeffrey Williams
  Problems are opportunities brilliantly disguised as insurmountable obstacles.

  How to post questions to get better answers faster
  Managing Transaction Logs

• Bruin

  SSCommitted

  Points: 1802

  More actions

  July 12, 2021 at 10:44 pm

  #3907161

  Backup of file:

  $date = get-date -uformat "_%d_%m_%Y_%H%M%S.bak"

  $newname=($csv -replace ".csv",$date)

  Rename-Item $csv $newname

  Count:

  $count=($csv).Count

  $count

  Can I just add this to the bottom of my script?

  Thanks.

• Phil Parkin

  SSC Guru

  Points: 245746

  More actions

  July 13, 2021 at 8:05 am

  #3907261

  Bruin wrote:

  Backup of file: $date = get-date -uformat "_%d_%m_%Y_%H%M%S.bak" $newname=($csv -replace ".csv",$date) Rename-Item $csv $newname

  Count: $count=($csv).Count $count

  Can I just add this to the bottom of my script?

  Thanks.

  Why not try and find out, rather than asking people here to do it for you?

  If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.