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

<< Newer    Items 41 to 60 of 91    Older >>
 

Coupling Outlook to SQL Server

SQL Server has drivers to read almost any data source, but they are not always the easiest to work with. New author Kevin Terry spent quite some time learning how he could pull data from Outlook using DTS and scripting. Most information on the internet requires Exchange to be on the same server as SQL Server to get the data, but this solution works with any configuration, and can pull any information, email address, contact information, etc. from Outlook.   Read more...
By Kevin Terry 2005/02/01 | Source: SQLServerCentral.com | Category: dts
Rating: |  Discuss |   Briefcase | 17,950 reads

Restore multiple DTS packages

This article examines how to take advantage of VB Script and MS-DOS batch files to restore multiple DTS packages stored in the form of structured storage files from one folder to a SQL Server box.   Read more...
By Additional Articles 2004/10/20 | Source: Database Journal | Category: dts
Rating:  Rate this |   Briefcase | 1,824 reads

DTS: Copy Objects Task

SQL Server DTS may be one of the best tools ever included with a database server. It makes data movement, copying, any sort of ETL task a breeze. At least for the most part. Bruce Szabo found a place where the Copy Objects task sometimes doesn't work as expected. This article looks a problem he had as well as the solution that you can use to ensure that this task works reliably for you.   Read more...
By Bruce Szabo 2004/10/13 | Source: SQLServerCentral.com | Category: dts
Rating: |  Discuss |   Briefcase | 8,679 reads

Automating "Save DTS package"

MAK examines how to save all of the DTS packages from SQL Server to a structured storage file automatically.  Read more...
By Additional Articles 2004/10/07 | Source: Database Journal | Category: dts
Rating:  Rate this |   Briefcase | 2,170 reads

Redistributing DTS with your program

Have you ever wanted to run DTS on a workstation or server that doesn't have SQL installed? Here's the items you need to move to make it happen.   Read more...
By Additional Articles 2004/09/15 | Source: SQLDTS.com | Category: dts
Rating:  Rate this |   Briefcase | 1,371 reads

Locking Down DTS

There's no security role to prevent or allow users to creating DTS Packages. Find out how to lock down DTS on your system.   Read more...
By Brian Knight 2004/09/10 (first published: 2001/04/21) | Source: SQLServerCentral.com | Category: dts
Rating: |  Discuss |   Briefcase | 8,280 reads

Using Different Techniques for SQL Server Automation

Automating SQL Server tasks is the sign of an experienced DBA. One who doesn't waste time on repetitive tasks that can be easily setup in a job, task, or some other scheduling process to run when they need to run. Haidong Ji has written a number of articles on how to perform automation and brings us yet another technique. This time he looks at managing your backup files, something that we all need to do, but all too often forget to do.   Read more...
By Haidong Ji 2004/08/02 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 17,295 reads

Comparison of Oracle Drivers

Oracle is usually a dirty word in the SQL Server community, but like it or not, lots of data resides in Oracle databases. And SQL Server is often used to gather this data together in a warehouse of some sort for spinning cubes, generating reports, etc. Haidong Ji looks at the various methods that you can connect to an Oracle driver and compares the speed of each. If you need to get data from Oracle, or may need to, this is the place you want to start.   Read more...
By Haidong Ji 2004/07/21 | Source: SQLServerCentral.com | Category: dts
Rating: |  Discuss |   Briefcase | 15,847 reads

DTS Parallel Processing

SQL Server DTS is an amazing ETL tool. Parallel processing is not only possible, but author Leo Peysakhovich shows us how he does it in this article about his index rebuild process. By bundling DTS into SQL Server for free, Microsoft gave us a platform for not only ETL, but also many basic tasks that all DBAs are stuck working on. Read on to see if parallel processing of index rebuilds is something you can use.   Read more...
By Leo Peysakhovich 2004/07/13 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 9,718 reads

Data Migration - Quickly Inserting New Data

Migrating data from one SQL Server database to another can be challenging. Steve Jones has a new series that looks at various techniques that he's used to move data into a new database. This one looks at how you can quickly take Excel based data and insert it into a new database without using DTS.   Read more...
By Steve Jones 2004/07/08 | Source: SQLServerCentral.com | Category: dts
Rating: |  Discuss |   Briefcase | 10,487 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: SQLServerCentral.com | Category: dts
Rating: |  Discuss |   Briefcase | 39,696 reads

Restore a DTS package from a DTS Store

Probably not a task you'll have to do very often, all the better that someone has laid out how to do it in good detail!   Read more...
By Bruce Szabo 2004/04/08 | Source: SQLServerCentral.com | Category: dts
Rating: |  Discuss |   Briefcase | 9,776 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: SQLServerCentral.com | Category: dts
Rating: |  Discuss |   Briefcase | 47,710 reads

A DTS Data Store

Looks at some basic concepts of DTS and a couple ideas for putting it to work.   Read more...
By Bruce Szabo 2004/03/08 | Source: SQLServerCentral.com | Category: dts
Rating: |  Discuss |   Briefcase | 10,866 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,002 reads

Auditing DTS Packages

In this follow up article, Haidong explains how to audit DTS packages. While parts of it are specific to DTS, the general technique has many useful applications.   Read more...
By Haidong Ji 2003/10/06 | Source: SQLServerCentral.com | Category: dts
Rating: |  Discuss |   Briefcase | 8,897 reads

Automate DTS Logging

DTS logging is a pretty handy feature - if you've got it enabled. Got lots of packages and want to turn it on for all of them? Thats a lot of point and click using EM, but with the code Haidong has put together, it's a snap. Other possibilities to this code as well. After all, it uses a DTS package to modify other DTS packages.   Read more...
By Haidong Ji 2003/09/09 | Source: SQLServerCentral.com | Category: dts
Rating: |  Discuss |   Briefcase | 11,961 reads

SQL Server DTS Best Practices

This article discusses various SQL Server Data Transformation Services (DTS) best practices. It is divided into sections like DTS naming conventions, DTS documentation, troubleshooting DTS packages, improving the performance of DTS packages, securing DTS packages, DTS resources.   Read more...
By Additional Articles 2003/06/24 | Source: Other | Category: dts
Rating:  Rate this |   Briefcase | 3,564 reads

Trapping DTS errors with Transact-SQL

Joe has written some articles for us, he also some interesting comment on his site - this article looks at trapping errors such as timeouts or divide by zero.  Read more...
By Additional Articles 2003/05/27 | Source: Other | Category: dts
Rating:  Rate this |   Briefcase | 2,172 reads

Portable DTS Packages

Have you ever faced the situation where you have needed to move a DTS package you needed to move a DTS package from one server to another, say from development to production? In this article by Kevin Feit, he shows you how to make a DTS package portable and save time.   Read more...
By Kevin Feit 2005/05/20 (first published: 2003/05/09) | Source: SQLServerCentral.com | Category: dts
Rating: |  Discuss |   Briefcase | 33,878 reads
<< Newer    Items 41 to 60 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)