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, 3 months ago.

  • Author
    Posts
  • #73810

    Participant
    Points: 0
    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
    Points: 0
    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.