load xls file to sql

• Jeffrey Williams

  SSC Guru

  Points: 90303

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

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

  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?

  The absence of evidence is not evidence of absence
  - Martin Rees
  The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
  - Phil Parkin