The problem design wise with the FAQ is that, as people have said, it is a major PITA to keep web pages updated in this fashion. It would probably be better using code that picked up text files that were dropped in a specific folder and displaying the contents linking on titles. This lowers the amount of 'link management' that would be required and means changes would be easy to add. This would need an aspx type site (or other language based dynamic loader). I did something similar once for a CCG. I had a web components that just scanned a folder. If anything appeared it picked it up displayed it and added a link to another control. Then all I had to do was drop the cards in the folder and the website was done. Minimal effort on my part. The nice bit was the component could be used by other websites either locally or by linking in.
Joss
If you mean using SSIS?
Then yes it can, but you have to be a programmer.
You have a SSIS package that an SQL agent job calls every hour.
Does File exist, NO, exit.
Else yes.
Is file Processed? if yes the archive it
Else
Process it
Then Archive it.
You need a batch processing table and a file table with your staging table.
It's still a pain no matter how you cut it, doing updates if doing it in your spare time. I say to those who think they can do it, then go and make your own FAQ site. When I first got back into ASL I was upset about the dead links, then after awhile I got tired of my own sites. I had two going, one for my Wiccan shop, I had over 2000 items on there, and then the baseball replay site. I closed my shop at the end of Dec. the baseball site hasn't been updated for a few months. it just gets to be big pain.
http://blmbaseball.site40.net/Index.html
Bill