Wrox Programmer Forums
Go Back   Wrox Programmer Forums > SQL Server > SQL Server DTS
SQL Server DTS Discussion specific to Data Transformation Service with SQL Server. General SQL Server discussions should use the general SQL Server forum. Readers of the book Professional SQL Server 2000 DTS with questions specific to that book should post in that book forum.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server DTS section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old November 28th, 2005, 04:52 PM
Friend of Wrox
Join Date: Oct 2005
Posts: 173
Thanks: 0
Thanked 2 Times in 1 Post
Default Directory Importing


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!

Old November 29th, 2005, 01:29 PM
Authorized User
Join Date: Sep 2005
Posts: 95
Thanks: 0
Thanked 0 Times in 0 Posts

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/
Old November 30th, 2005, 05:37 AM
Friend of Wrox
Join Date: Oct 2005
Posts: 173
Thanks: 0
Thanked 2 Times in 1 Post

Thats an excellent online resource.

Many thanks


Similar Threads
Thread Thread Starter Forum Replies Last Post
Importing into Access hewstone999 Access VBA 1 March 6th, 2008 08:40 AM
Importing CSV inspiron SQL Server DTS 1 October 24th, 2006 03:17 PM
Importing from Excel bmains ADO.NET 1 October 9th, 2004 11:44 AM
importing from one table to another jtyson SQL Server 2000 1 June 3rd, 2004 11:34 AM
Importing a TextFile, best way ioates SQL Server 2000 1 June 27th, 2003 07:24 AM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.