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.
Author: SSWUG Research
XML Advances on B2B Front
(Dan Wahlin) Extensible Markup Language (XML) has evolved considerably in its short five-year history. It started out as a simple way to mark up data and relied on seasoned technologies for data validation, such as document type definitions (DTDs). As XML has matured, the World Wide Web Consortium (
Oracle Goes Grid
Oracle Corp. has announced plans to incorporate grid-computing techniques and standards across its product line in the forthcoming Oracle 10g release. According to Robert Shimp, Oracle vice president of database marketing, “grid computing will be every bit as significant as the Internet” in its impo
DB2 Universal Database for Windows High Availability Support Using Microsoft Cluster Server
(Aslam Nomani and Lan Pham) DB2 Universal Database (UDB) is the industry’s first multimedia, Web-ready relational database management system, strong enough to meet the demands of large corporations and flexible enough to serve medium-sized and small e-businesses. DB2 Universal Database combines inte
Smarter Solutions Defy Old Comparisons
(Jim Mulkey and Nancy Lilly) In the world of DB2 utilities, great emphasis is placed on the contrasts between one vendor’s performance benchmark and another’s. However, benchmarks no longer tell the whole story. The requirements for backup and recovery, as well as the method used to evaluate the suc
Transferring DTS Packages
(Darren Green) This article will try and explain the different ways you can transfer packages between servers and other storage locations, either directly or as files. The most common requirement is to transfer between two SQL Servers, and this is the main focus here, but some methods can be adapted
Reading, Storing and Transforming XML Data in .NET – Introduction
(Dimitrios Markatos) Unless you happened to be involved in some other career field, it would almost impossible to not realize that XML is steadily growing as a common data exchange format that can used be across any platform. As long as you conform to standard XML specifications, you can send your X
Porting Unmanaged Legacy C++ Applications That Interact with DB2 Mainframes into .NET/C#
(Satender Saroha) Recently there has been a sudden increase in new development projects for migrating existing C/C++ applications written on the UNIX/Windows platform to .NET. There are a variety of reasons for that, foremost among them being the desire to utilize the wide range of capabilities the
Showdown-bcp vs. DTS
Every SQL Server application manager needs to move a large amount of data into or out of a SQL Server database at least once, so SQL Server has several tools for bulk data-transfer operations. In this article, I compare two familiar SQL Server utility programs—bulk copy program (bcp) and Data Transf
An Introduction to Schematron
(Eddie Robertsson) The Schematron schema language differs from most other XML schema languages in that it is a rule-based language that uses path expressions instead of grammars. This means that instead of creating a grammar for an XML document, a Schematron schema makes assertions applied to a spec