In Data Transformation Services (DTS), you can extend the capabilities of your DTS package by using Microsoft ActiveX scripts that implement the objects, properties, methods, and collections of the DTS object model. Using ActiveX scripts, you can: –Format and transform the data as it is copied
Other News
SQLOS’s memory manager and SQL Server’s Buffer Pool
(Slava Oks) SQLOS’s memory manager consists of several components such as memory nodes, memory clerks, memory caches, and memory objects.
Installing Oracle Database 10g on Novell SUSE Linux Enterprise Server 9 and on SUSE Linux Professional 9.1
(Werner Puschitz) The following procedure is a step-by-step guide (Cookbook) with tips and information for installing Oracle Database 10g on SUSE Linux.
.Net Development with DB2 database
This Rational Software Development Platform Webcast explains how easy it is to develop .NET applications using Visual Basic or C# using DB2 as your database environment. As a long-standing premier member of the Microsoft Visual Studio Industry Partner (VSIP) program, IBM has already delivered an imp
Your Introduction to the My Object in VS 2005
(Paul Kimmel) VB can be a completely object-oriented language and still find ways to enhance productivity. One of the ways that Microsoft is still finding innovative ways to increase productivity without making VB.NET a second-class language is the introduction of the My object, which will ship in V
Faster XML ahead?
(Martin LaMonica) The W3C is closer to tackling sluggish XML performance, but not everyone agrees with the group’s approach. (R)
Migration prep, part 2: Comparing MySQL and MS SQL Server
(Jan Stafford) Microsoft SQL Server does have features that can’t be found in MySQL 4, according to Mike Sheffey, CEO of migration tools vendor Versora. But that situation is probably temporary. In part two of our series on migrating to MySQL, Sheffey discusses what users need to know about thos
Code Snippets in VS.NET 2005 – Part 2
(Saravana Kumar) During application development, you might come across a situation where you need to write the same code repeatedly with just a few changes. For example, you may write code to fetch data from the database many times in your application. In this case, you will open a text file, wh
FIX: An invalid cursor state occurs after you apply Hotfix 8.00.0859 or later in SQL Server 2000
After you apply post-Microsoft SQL Server 2000 Service Pack 3 (SP3) hotfix build versions between 8.00.0859 and 8.00.0875, applications that execute a stored procedure that uses a SET NOCOUNT ON statement and that return one or more result sets following an informational message, a RAISERROR stateme
HOWTO – Work with LOB Data Types
(Torsten Schlabach) In a lot of applications there is a need to store large text or binary objects into the database. The definition of large usually means that the object’s size is beyond the maximum length of a character field. In Oracle this means the objects to be stored can grow to > 4 KB each.