Load 2 files to SQL on 1 connection

• Bruin

  SSCrazy

  Points: 2107

  More actions

  September 24, 2021 at 4:08 pm

  #3932799

  I have 2 files I'm importing and have 2 different SQL tables from the same database. How could I create one connection to the

  DB and load to 2 different SQL tables.

  Thanks.

  $f1=(import-csv 'c:\temp\dbsessinfo' -Delimiter '|' -header dbsession,client,qaduser,osuser,pts,qadpgm,qadmenu,pid,ostask,runtime)
  $f2=(import-csv 'c:\temp\dbwaitdata' -Delimiter '|' -header dbanme,progtxn,osuser,locktype,locktbl,lockrcd,lockmeth)

   

   

• Site Owners

  SSC Guru

  Points: 80342

  More actions

  September 25, 2021 at 4:10 pm

  #3933057

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.

• Bruin

  SSCrazy

  Points: 2107

  More actions

  September 28, 2021 at 2:37 pm

  #3934150

  I have it figured out.

  Thanks.