« Previous Next »

Thread: How to append data

Last post 10-22-2009 3:39 PM by agc1. 1 replies.

Average Rating Rate It (5)

RSS

Page 1 of 1 (2 items)

Sort Posts:

Shortcuts

Search | Active Posts | Unanswered Posts | View all users

  • 05-11-2009, 12:16 PM

    • adoyt
    • Not Ranked
    • Joined on 10-14-2008, 8:12 PM
    • Posts 2

    How to append data

    Reply Contact

    I'm using logparser to upload data to a SQL DB and my DBA has some audit elements that they require be populated.  So, I need to add my username and the current time to the list of fields being populated. 

     

    TYIA

  • 10-22-2009, 3:39 PM In reply to

    • agc1
    • Not Ranked
    • Joined on 10-22-2009, 3:29 PM
    • Posts 3

    Re: How to append data

    Reply Contact

    Try exporting your data first to CSV then use vbscript to add username and timestamp to each row, then upload to SQL (its a workaround but it could get the job done for you)

Page 1 of 1 (2 items)
Microsoft Communities