Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 201785 - Last Review: July 1, 2004 - Revision: 3.3
How To Import FileSystem Data Using DTS and Index Server
This article was previously published under Q201785
This article describes how to import FileSystem data into SQL Server 7.0 using SQL Data Transformation Services (DTS) and Index Server OLE DB provider.
DTS Import Wizard does not show Index Server OLE DB Provider in the list of sources. However, you can specify a distributed query with Index Server OLE DB provider as the source of your data.
Steps to Copy FileSystem Data
- Run SQL Enterprise Manager and run Data Transformation Import Wizard.
- Choose SQL Server 7.0 as the source.
- Choose SQL Server 7.0 as destination. Specify the destination database.
- Choose the option "Use a query to specify the data to transfer," which opens a query window. Type a valid Index Server distributed query using OpenQuery or OpenRowset. For example:
SELECT a.*
FROM OpenRowset('MSIDXS','Web';''; '', 'Select Directory, FileName, size, Create, Write
from SCOPE()
where CONTAINS(''"Index Server" ~ "SQL Server"'')> 0
and FileName LIKE ''%.htm%'' ') AS a
- Parse the query to make sure the SQL Statement is valid. Click Next to see information on source and destination table.
You can click Transform if you need to apply custom transformations. You can also view the source data by clicking Preview. - Click Next to run the DTS package.
For more details on setting up and using Distributed Queries, please see:
SQL 7.0 Books Online: sp_addlinkedserver; OpenQuery; OpenRowset;
For more information on using MSDIXS provider, refer to the Index Server documentation in the Windows NT 4.0 Option Pack documentation.
APPLIES TO
- Microsoft SQL Server 7.0 Standard Edition
- Microsoft OLE DB Provider for Index Server 2.0
- Microsoft SQL Server 2000 Standard Edition
| kbdatabase kbhowto KB201785 |
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate