Hi

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!

Rit

__________________
Rit
www.designandonline.co.uk
INSPIRE | CREATE | DELIVER

Yes it is
use the file system object to loop through a directory, get the filename, read the content into a string and store the string into a table
Go to http://www.sqldts.com for examples

“I sense many useless updates in you... Useless updates lead to fragmentation... Fragmentation leads to downtime...Downtime leads to suffering..Fragmentation is the path to the darkside.. DBCC INDEXDEFRAG and DBCC DBREINDEX are the force...May the force be with you" -- http://sqlservercode.blogspot.com/

Thats an excellent online resource.

Many thanks

Rit