Marcin Policht

In the arsenal of DTS Designer Tasks, the one that leads in terms of versatility (and complexity) is the Data Driven Query Task. Its most distinctive feature, distancing it from other tasks, is its ability to not only handle inserts of rows during transformation, but also process any other T-SQL statements, such as UPDATEs, DELETEs, […]

In our previous article, we started discussing basic principles and applications of the Transform Data task. We will continue this topic here, focusing on its more advanced features. So far, we have described the purpose of four of the tabs of the Transform Data Task Properties dialog box in the most basic scenario, without resorting […]

A few more DTS Designer tasks are left to cover out of a total of 17 existing in SQL Server 2000 Data Transformation Services implementation. Arguably, the one that has undergone the most significant changes since the SQL 7.0 release is the Transform Data Task. In this article, we will look at its default behavior. […]

If you have been following our series of articles discussing SQL Server DTS technology, you probably have noticed frequent references to ActiveX-based scripting. While scripting is not very popular among database administrators, its potentials are worth exploring, especially since familiarity with its concepts is required to fully understand the remaining types of tasks we will […]

As we indicated in our previous article, we are going to continue discussing various ways of utilizing global variables in DTS Designer tasks. In particular, we will look into their role in exchanging data between packages, using features built into the Execute Package task. As part of this discussion, we will also explain the purpose […]

In the previous article of this series, we covered types of DTS Designer tasks that are more straightforward. We will continue this discussion here, focusing on ones that are more complex. However, before we proceed, we will look into the concept of DTS Global Variables, which will help us understand some of the options available […]

In the previous article of our series dedicated to SQL Server 2000 Data Transformation Services, we covered the first of the essential elements of a package – connection. Now it is time to look into another critical component – task – that is responsible for the processing of data retrieved through connections. Tasks are represented […]

In our previous article of this series, we presented a way of creating DTS packages with wizards. Despite its simplicity, this approach has some limitations, which you can overcome in two ways – by using DTS Designer or by manipulating DTS object model with programming languages, such as Visual Basic. While the second of these […]

As we explained in the first article of this series, there are three methods of creating DTS packages – with DTS Designer graphical interface, with programming by directly using the DTS object model, or with wizards available from the SQL Server Enterprise Manager interface. We will focus here on the third method, which despite being […]

As a database administrator, besides manipulation of the data residing in SQL Server 2000 databases, you are frequently faced with tasks that deal with transfer of data between diverse data sources. Frequently, such data needs to be also transformed or altered during the transfer. In the past (in SQL 6.5 and earlier), such issues presented […]

In the last article of this series, we will focus on Web Services and their implementation in the SQL Server 2000 environment with the help of the SQLXML component. In particular, we will look into a non-programmatic way of publishing SQL Server 2000 stored procedures, user-defined functions and XML templates as Web Services. Note that […]

Throughout the most recent articles of this series, we have been covering a range of new features introduced in SQLXML 2.0. We are continuing this trend by presenting the client-side XML processing. Let’s start by defining what this term signifies. In its typical configuration (original version included with SQL Server 2000 and default configuration with […]