Inserting data to SQL table

Welcome Forums General PowerShell Q&A Inserting data to SQL table

This topic contains 1 reply, has 2 voices, and was last updated by

1 year, 10 months ago.

  • Author
  • #73810

    Topics: 40
    Replies: 41
    Points: 11
    Rank: Member

    I have a table in SQL named: abc & columns as "Aggregation Start Time, Aggregation End Time, Time Taken for whole process".

    I have text file with below data:
    Aggregation Start Time – 2017-06-27 22.30.00
    Aggregation End Time – 2017-06-28 01.25.35
    Time taken for whole process – 10288

    It has to dump the data in text file to abc table as per the column names.

    I tried lot of the things & it did not help. Can someone guide me on this.


  • #73859

    Topics: 6
    Replies: 650
    Points: 2
    Rank: Member

    Don Jones made a nice little powershell module for posting data to SQL. You should check out "Ditch Excel: Historical and Trend Reports with PowerShell and SQL Server" in the eBooks section.

The topic ‘Inserting data to SQL table’ is closed to new replies.

denizli escort samsun escort muğla escort ataşehir escort kuşadası escort