Post reply

Load 2 files to SQL on 1 connection

  • 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)

     

     

  • 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.

  • September 28, 2021 at 2:37 pm

    #3934150

    I have it figured out.

    Thanks.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply