load xls file to sql

• Jeffrey Williams

  SSC Guru

  Points: 90350

  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
  “We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

  ― Charles R. Swindoll

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

• Bruin

  SSCrazy

  Points: 2107

  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: 247180

  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?

  ---