Post reply

Automatically Saving HTML files data in table columns

  • May 22, 2008 at 2:56 am

    #186800

    Hi All,

    I am looking for a store procedure or any alternate method which save my html file(s) text (with or without tags) in my table column automatically when I upload my html file to my file system (local hard drive).

    any help will be appreciate.

    Thanks in advance.

  • May 30, 2008 at 2:27 am

    #822143

    Consider using SSIS for this. You can automate the process by using WMI event handlers.

    All the details are available in Books Online, but you might also find more accurate answers here: http://www.sqlis.com/.

    ML

    ---
    Matija Lah, SQL Server MVP
    http://milambda.blogspot.com

  • May 30, 2008 at 9:00 am

    #822385

    Thanks for the reply.

    I am using Sql Server Express 2005, I think SSIS option is not available in it. And what about striping HTML tags from the text, did SSIS can handle that option either.

    Thanks

  • May 30, 2008 at 9:21 am

    #822407

    With SQL Server Express your best option would be to design a client application that will monitor the file system and then insert the file into the database. Especially so, if additional processing is required - which would otherwise be difficult to achieve using only T-SQL (SQL Server 2005 does support the XML data type, but not all HTML documents are well-formed XML entities).

    ML

    ---
    Matija Lah, SQL Server MVP
    http://milambda.blogspot.com

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

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