Post reply

httplog into table

  • December 1, 2008 at 12:45 am

    #128977

    Hy,

    I need to insert contents of http (somtehing like this http://xx.xx.xx.xx/httplog) into table in sql 2005 express. How can i do this? Can I reed contents of httplog directly into table (varchar 1000) or I need to use third party software?

    Please help!

  • December 1, 2008 at 2:01 am

    #905410

    Dear

    I think you should first extract data from http location then try to insert data in sql server 2005.

    Thanx

    Thanks

  • December 2, 2008 at 9:56 am

    #906333

    You can use WGET utility in the script, it will place the downloaded file to your local hard drive and then the next step of the job will be to upload data from the file using either SSIS, BCP or BULK INSERT statement

    Make sure you install WGET for Windows:

    http://users.ugent.be/~bpuype/wget/

    Regards,Yelena Varsha

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

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