This article provides the required code for a DTS ActiveX Script task, that overwrites the DTS package error files, and prevents them from growing huge!
Other News
Another German Yak … with a suprise
From SQLTeam – This Reader Challenge #3 solution is quite a bit different from the first solution I posted. And it’s chock full of “sqlicious” goodness. And a suprise at the end!
The basics of using XML Schema to define elements
[Editorial] This is a great overview of using XML schemas – good, strong how-to piece. [/Editorial] <br><Br> The new XML Schema system aims to provide a rich grammatical structure for XML documents that overcomes the limitations of the DTD. This article demonstrates the flexibility of schemas and
Things to Know and Avoid When Querying XML Documents with XPath
(By Dare Obasanjo, Microsoft Corporation) Inspiration for this article arose from a weekend where nothing that I expected to work on actually panned out. My significant other decided to take a celebratory trip to Las Vegas with a coworker, which coincided quite nicely with my plans to go to Ikea and
Implementing XPath for Wireless Devices, Part II
In this article, Bilal Siddiqui will discuss the features of XPath which allow for complex search operations on an XML file. He will discuss predicates or filtered queries and the use of functions in XPath. He will present various XPath queries for the processing of WSDL and WML. Bilal w
Precise Software Adds Performance Management For SQL Server
By Barbara Darrow – Precise Software Solutions this week added a performance management tool for SQL Server 2000 to its roster. Available now, the Precise/Indepth software uses technology developed by the company with Microsoft to glean better metrics about database performance.
Microsoft Windows Server DevCon 2002: Sept. 3 – 6
Learn from Microsoft experts how to code scalable, secure, high-performance server and datacenter applications for Windows 2000 and Windows .NET Servers.
Performing a Log Shipping Role Change
How do I create stored procedures for performing a log shipping role change without having to create a Data Transformation Services (DTS) package to copy the logins from the primary server to the secondary server?
JDBC Transaction Optimization
By Jack Shirazi – Transactions make a developer’s job a lot easier. By using the transaction capabilities within the JDBC API and relational databases such as Oracle9i, you can minimize possible data corruption when updating multiuser applications. Transactions require processing overhead, however,
IBM Rolls Out New Database Software
By Jennifer LeClaire – In a move to compete with rival Oracle’s new 9i database management software, IBM has released a beta version of its new DB2 database. According to IBM executives, the latest software is faster and more reliable than its predecessor, with improved support for Web services.