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

 
Participant
1 year, 10 months ago.

  • Author
    Posts
  • #73810

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

    Hi,
    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.

    -Kalyan

  • #73859

    Participant
    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