Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tags DTS, SQL Server 7 Rss

   Items 1 to 20 of 91    Older >>
 

Powering up DTS with PerlDTS

This article introduces the PerlDTS project that provides a Perl distribution to access and execute MS SQL Server 8 DTS packages.  Read more...
By Alceu Rodrigues de Freitas Junior 2008/12/22 | Source: SQLServerCentral.com | Category: perl
Rating: |  Discuss |   Briefcase | 2,765 reads

Conditional Flow in DTS

While SQL Server Integration Services is a huge improvement in the ETL capabilities of SQL Server, there are quite a few environments still using DTS in SQL Server 2000. Wayne Fillis brings us a method for implementing conditional logic in your packages.   Read more...
By Wayne Fillis 2007/06/07 | Source: SQLServerCentral.com | Category: dts
Rating: |  Discuss |   Briefcase | 9,968 reads

Five Realtime DTS Examples

SQL Server 2005 includes an amazing ETL environment in Integration Services, but many DBAs will be using DTS and SQL Server 2000 for years to come. Jambu Krishnamurthy brings us a few handy examples of how you can customize your DTS environment.   Read more...
By Jambu Krishnamurthy 2007/03/22 | Source: SQLServerCentral.com | Category: dts
Rating: |  Discuss |   Briefcase | 16,910 reads

The Dynamic Process of Loading Data

When loading a data warehouse, handling the ETL process of working with files can be problematic. Longtime DBA Janet Wong brings us an interesting solution that is flexible and efficient for quickly loading a number of files into a warehouse using DTS.   Read more...
By Janet Wong 2007/01/23 | Source: SQLServerCentral.com | Category: dts
Rating: |  Discuss |   Briefcase | 9,887 reads

Overview of DTS Packages

While SQL Server 2005 is greatly changing the paradigm of ETL with Integration Services, SQL Server 2000 and DTS will be here for some time to come. New author Rama Nageshwara brings us an overview of this fantastic data movement toolset.   Read more...
By Rama Nageshwara 2007/12/21 (first published: 2005/11/09) | Source: SQLServerCentral.com | Category: dts
Rating: |  Discuss |   Briefcase | 26,839 reads

Exception handling in DTS

While SSIS is taking the SQL Server 2005 world by storm, there are many DBAs still working with SQL Server 2000 and its ETL system: DTS. In this article, Jambu Krishnamurthy shows us how to modify the exception handling in a DTS package to get around the limitations of the designer.   Read more...
By Jambu Krishnamurthy 2006/12/19 | Source: SQLServerCentral.com | Category: dts
Rating: |  Discuss |   Briefcase | 9,010 reads

Monitoring on a Budget

Have you ever been asked for information you couldn't provide because you didn't have an historical monitoring tool? Try this  Read more...
By Bert Carles 2007/11/19 | Source: SQLServerCentral.com | Category: monitoring
Rating: |  Discuss |   Briefcase | 9,072 reads

Migrating SQL Server 2000 DTS Packages Across Environments

Many of us still have SQL Server 2000 DTS packages running throughout our environment. New author Owais Bashir Ahmed brings us an interesting technique for moving those packages between servers that might come in handy as you continue to work on these packages in SQL Server 2000.  Read more...
By Owais Bashir Ahmed 2007/10/09 | Source: SQLServerCentral.com | Category: dts
Rating: |  Discuss |   Briefcase | 6,089 reads

Maintain DTS packages in SQL Server 2005

Migrate to SQL Server 2005 and maintain, edit and develop your data transformation services (DTS) packages using the SQL Server DTS Designer.  Read more...
By Additional Articles 2007/07/05 | Source: SearchSQLServer | Category: dts
Rating:  Rate this |   Briefcase | 4,153 reads

Conditional Flow in DTS

While SQL Server Integration Services is a huge improvement in the ETL capabilities of SQL Server, there are quite a few environments still using DTS in SQL Server 2000. Wayne Fillis brings us a method for implementing conditional logic in your packages.   Read more...
By Wayne Fillis 2007/06/07 | Source: SQLServerCentral.com | Category: dts
Rating: |  Discuss |   Briefcase | 9,968 reads

Five Realtime DTS Examples

SQL Server 2005 includes an amazing ETL environment in Integration Services, but many DBAs will be using DTS and SQL Server 2000 for years to come. Jambu Krishnamurthy brings us a few handy examples of how you can customize your DTS environment.   Read more...
By Jambu Krishnamurthy 2007/03/22 | Source: SQLServerCentral.com | Category: dts
Rating: |  Discuss |   Briefcase | 16,910 reads

The Dynamic Process of Loading Data

When loading a data warehouse, handling the ETL process of working with files can be problematic. Longtime DBA Janet Wong brings us an interesting solution that is flexible and efficient for quickly loading a number of files into a warehouse using DTS.   Read more...
By Janet Wong 2007/01/23 | Source: SQLServerCentral.com | Category: dts
Rating: |  Discuss |   Briefcase | 9,887 reads

Exception handling in DTS

While SSIS is taking the SQL Server 2005 world by storm, there are many DBAs still working with SQL Server 2000 and its ETL system: DTS. In this article, Jambu Krishnamurthy shows us how to modify the exception handling in a DTS package to get around the limitations of the designer.   Read more...
By Jambu Krishnamurthy 2006/12/19 | Source: SQLServerCentral.com | Category: dts
Rating: |  Discuss |   Briefcase | 9,010 reads

Managing DTS packages - Editing, Scheduling, and Viewing Package Logs

In the second of a series of articles that targets the DBA new to an organization, this article looks at how to manage DTS packages.   Read more...
By Haidong Ji 2006/10/06 (first published: 2003/01/02) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 40,640 reads

Executing a Package from Visual Basic

So you've created a SQL Server package and now you're ready to integrate it into your Visual Basic application? In this series, Brian Knight will show you how to use the DTS object model to execute a DTS package from Visual Basic.   Read more...
By Brian Knight 2006/08/18 (first published: 2004/01/23) | Source: SQLServerCentral.com | Category: dts
Rating: |  Discuss |   Briefcase | 25,005 reads

Committing imports in SQL Server a little at a time

A colleague working on an Informix database needed to search TEXT columns using wildcards. While Informix supports wildcards in LIKE and MATCH predicates, this support does not include TEXT columns. The obvious solution—to export the data to SQL Server—does support such searches.  Read more...
By Additional Articles 2006/08/03 | Source: Builder.com | Category: dts
Rating:  Rate this |   Briefcase | 2,022 reads

Copying DTS Packages To a Different Server

How do you easily copy DTS packages from one server to another? DTS, BCP, T-SQL? Are there advantages to using one method over another? Andy did some research - read the article and see what works and what doesn't!   Read more...
By Andy Warren 2006/05/05 (first published: 2002/03/19) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 37,486 reads

Handling Zero Byte Files in DTS

SQL Server 2005 has substantially enhanced its ETL capabilities, but many people will still be working with DTS in SQL Server 2000 for many years. New author James Greaves brings us a technique for working with imports and handling files that might not have any data.   Read more...
By James Greaves 2006/03/27 | Source: SQLServerCentral.com | Category: dts
Rating: |  Discuss |   Briefcase | 6,765 reads

DTS and Global Variables

SQL Server 2000's DTS subsystem is a tremendously flexible environment for handling any number of tasks on your SQL Server. Alex Kersha used DTS to implment a task that manages the number of backup files on his server, which is conifgurable with a global variable. Read on and get the code to implement this task on your servers.   Read more...
By Alex Kersha 2006/02/20 | Source: SQLServerCentral.com | Category: dts
Rating: |  Discuss |   Briefcase | 19,645 reads

SED and the Big Bad UNIX File

One would think that when you have to work with Unix text files, they would be the same as Windows text files. That is not quite the case and Peter Ward brings us a look at how this caused a problem in DTS and a way you can fix it.   Read more...
By Peter Ward 2006/01/10 | Source: SQLServerCentral.com | Category: dts
Rating: |  Discuss |   Briefcase | 9,194 reads
   Items 1 to 20 of 91    Older >>
 
Tags
administration (9)    
miscellaneous (9)    
programming (8)    
configuring (4)    
t-sql (4)    
visual basic 6 (4)    
backup / restore (3)    
performance tuning (3)    
security (3)    
stored procedures (3)    
data warehousing (2)    
distributed queries (2)    
indexing (2)    
installation (2)    
monitoring (2)    
reviews (2)    
strategies (2)    
triggers (2)    
user defined function (udf) (2)    
ado (1)    
advanced querying (1)    
best and worst practices (1)    
best practices (1)    
book reviews (1)    
capacity planning (1)    
design and theory (1)    
disaster recovery (dr) (1)    
english query (1)    
integration services (ssis) (1)    
openxml (1)    
perl (1)    
product reviews (1)    
replication (1)    
sql server 2005 (1)    
sql server 6.5 (1)    
system development life cycle (1)    
updategrams (1)    
xml (1)    
xsl (1)