Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Content with tag DTS Rss

<< Newer    Items 21 to 40 of 123    Older >>

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: | Category: dts
Rating: |  Discuss |   Briefcase | 9,899 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: | Category: dts
Rating: |  Discuss |   Briefcase | 9,017 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: | Category: administration
Rating: |  Discuss |   Briefcase | 40,674 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: | Category: dts
Rating: |  Discuss |   Briefcase | 25,020 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: | Category: dts
Rating:  Rate this |   Briefcase | 2,113 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: | Category: administration
Rating: |  Discuss |   Briefcase | 37,537 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: | Category: dts
Rating: |  Discuss |   Briefcase | 6,771 reads

You are using SQL Server 2000's DTS and...

By Steve Jones 2006/02/22 | Category: dts
Rating: (not yet rated) |  Discuss |   Briefcase | 1,920 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: | Category: dts
Rating: |  Discuss |   Briefcase | 19,672 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: | Category: dts
Rating: |  Discuss |   Briefcase | 9,199 reads

DTS Hashing

DTS is a great tool in SQL Server 2000 for easily setting up jobs to import or export data. But it can also have security risks. New author Alex Kersha brings us a simple security technique to be sure that you are properly executing your DTS packages in a secure manner.   Read more...
By Alex Kersha 2005/12/20 | Source: | Category: dts
Rating: |  Discuss |   Briefcase | 5,782 reads

Granting Execute Access to All Stored Procedures to a Given User

A quick and dirty procedure to allow you to grant execute permissions to a user, or role, quickly and easily.   Read more...
By Tim Mitchell 2005/12/13 | Source: | Category: dts
Rating: |  Discuss |   Briefcase | 9,522 reads

DTS Polling

Lots of packages exist that will import data files for you, even if you do not know the file name ahead of time. But most of them expect the files to be there. New author Andre Quitta brings us a technique he has for checking to see if the files are even there before importing them.   Read more...
By Andre Quitta 2005/12/05 | Source: | Category: dts
Rating: |  Discuss |   Briefcase | 8,465 reads

Data Migration : Step by Step

This article by Chris Kempster covers a wide variety of areas concerned with data migration. Primarily, it focuses on process, standards and some of the many issues to consider when undertaking this role.   Read more...
By Chris Kempster 2005/11/25 (first published: 2004/03/24) | Source: | Category: dts
Rating: |  Discuss |   Briefcase | 47,845 reads

Leveraging XP Excel , XML, and OPENXML for Data Imports

DTS is a fantastic ETL tool and it is often used to import Excel documents. However this can be a manual process in many cases in setting up the package. New author Sloan Holliday brings us a way that you can leverage Office XP's automation facilities and XML to import data into SQL Server.   Read more...
By Sloan Holliday 2005/11/22 | Source: | Category: dts
Rating: |  Discuss |   Briefcase | 10,658 reads

DTS Standards

SQL Server 2000 brought us DTS, a new way of working with data movement for SQL Server DBAs. However, unlike Integration Services and Project REAL, there weren't any great standards for working with this tool and building portable solutions was hard. Jonathan Stokes brings us a great article on how you can create a standard structure for your packages and make them more portable.   Read more...
By Jonathan Stokes 2005/11/21 | Source: | Category: dts
Rating: |  Discuss |   Briefcase | 8,598 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: | Category: dts
Rating: |  Discuss |   Briefcase | 26,862 reads

Have You Been Told Today

SQL Server 2000 has a great job and alert subsystem, but it doesn't do everything. There are times when you want to be notified that something has completed, or not completed. New author Frank Loschiavo brings us a way to ensure that when you run a query you are notified if and when it completes.   Read more...
By Frank Loschiavo 2005/10/20 | Source: | Category: dts
Rating: |  Discuss |   Briefcase | 6,124 reads

Using DTS to Generate and Email Excel Reports

Another great article from Joe Sack that looks at a great technique for generating reports in Excel for your users. Using DTS, you can easily setup an ad hoc or recurring schedule for your users. It's a way to quickly build a report that keeps people happy while making you look like a genius.   Read more...
By Joseph Sack 2005/09/23 (first published: 2004/05/03) | Source: | Category: dts
Rating: |  Discuss |   Briefcase | 39,741 reads

Can you run a DTS package on SQL...

By Steve Jones 2005/09/13 | Category: dts
Rating: (not yet rated) |  Discuss |   Briefcase | 1,737 reads
<< Newer    Items 21 to 40 of 123    Older >>
sql server 7 (76)    
administration (9)    
miscellaneous (9)    
programming (8)    
backup and restore (4)    
configuring (4)    
integration services (ssis) (4)    
t-sql (4)    
visual basic 6 (4)    
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)    
64-bit (1)    
ado (1)    
advanced querying (1)    
best and worst practices (1)    
best practices (1)    
blogs (1)    
book reviews (1)    
capacity planning (1)    
configuration (1)    
design and theory (1)    
disaster recovery (dr) (1)    
english query (1)    
error handling (1)    
error log (1)    
handle (1)    
ini (1)    
openxml (1)    
perl (1)    
portability (1)    
product reviews (1)    
replication (1)    
sql server (1)    
sql server 2005 (1)    
sql server 2008 (1)    
sql server 6.5 (1)    
system development life cycle (1)    
updategrams (1)    
vbscript (1)    
xml (1)    
xsl (1)