(Donald Farmer) In Chapter 2, you learned about the three types of Data Flow components in SSIS: sources, transformations and destinations. This chapter will describe these different types and show you how to create your fi rst transformation component using VB.NET in the Script Component. Once yo

(Jyoti Jacob, Donald Farmer and Len Wyatt) The first phase of Project REAL included the migration of existing SQL Server 2000 DTS packages to SQL Server 2005 Integration Services (SSIS) for a large electronic retailer. One source of information for the data warehouse was from TLog files, which conta

(Brian Walker) This tip continues the system stored procedure series with a routine to create a fixed-width file containing data from a single column. (R)

Presented as a Microsoft Mini-Code Camp, this full day of instruction highlights the programming aspects of SQL Server 2005 as it has evolved from SQL Server 2000. This presentation was authored and presented jointly with Adam Machanic.

During the installation of SQL Server 2000 Standard Edition using VLA media on a server running Windows 2000 SP4, you receive the error message “Unable to validate product key” on the CD-key page of the installation wizard.

(Narayana Vyas Kondreddi) This is a short article to make you aware of an error returned by “Expired subscription clean up” job, when you setup replication in SQL Server 2005 (Yukon). Though the “Expired subscription clean up” job fails with the below error, there is nothing wrong with your replicat

In Microsoft SQL Server 2000, you identify a named instance by using a combination of the computer name and the instance name that is specified as computernameinstancename. If the combination of the computer name and the instance name is more than 30 characters, you can create a new SQL Server Agen

(Jeremy Kadlec) In light of the impending SQL Server 2005 launch, many organizations are considering the upgrade but they don’t know where to start or how to get from point A to point B in a timely manner. This tip outlines the top 10 high-level steps to get you on the right path to a SQL Server 200

(Muthusamy Anantha Kumar) This article illustrates how to monitor CPU usage on different running process on one machine and on multiple machines. In many organizations, the SQL Server Database administrator and System administrators have the responsibility of trouble shooting and identifying the cau

(Serdar Yegulalp) Windows servers “announce” their presence on local networks via NetBIOS by default, so any other computer configured with a domain browser (essentially the Computer Browser service) can see a server without knowing its IP address. If you’re running SQL Server in an environment wher