I am a novice with SQL Server (currently reading Wrox's SQL Server 2000 Programming) and am wondering whether the following is possible?..
Scenario - I have a directory of about 1000 html files of which I need to find the most effective way of getting the content of these files and their filename into a SQL server database on my web host's server.
ID field = filename
Content field = html code
Is it possible to achieve this using DTS?
Many thanks in advance!
INSPIRE | CREATE | DELIVER