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

Content with tag DTS Rss

<< Newer    Items 61 to 80 of 123    Older >>
 

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

You are a DTS programmer who wishes to...

By Steve Jones 2004/05/05 | Category: dts
Rating: (not yet rated) |  Discuss |   Briefcase | 1,740 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

You are creating a DTS package in SQL...

By Steve Jones 2004/04/23 | Category: dts
Rating: (not yet rated) |  Discuss |   Briefcase | 1,753 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

You are a DTS programmer who is trying...

By Steve Jones 2004/03/10 | Category: dts
Rating: (not yet rated) |  Discuss |   Briefcase | 1,632 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

You are a DTS programmer that is trying...

By Steve Jones 2004/03/08 | Category: dts
Rating: (not yet rated) |  Discuss |   Briefcase | 2,284 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

What is the difference between user and owner...

By Steve Jones 2004/01/23 | Category: dts
Rating: (not yet rated) |  Discuss |   Briefcase | 1,067 reads

You are a DTS programmer who has created...

By Steve Jones 2004/01/07 | Category: dts
Rating: (not yet rated) |  Discuss |   Briefcase | 1,426 reads

You create a SQL Server 2000 Service Pack...

By Steve Jones 2003/12/18 | Category: dts
Rating: (not yet rated) |  Discuss |   Briefcase | 1,945 reads

You need to create a DTSRUN command to...

By Steve Jones 2003/12/08 | Category: dts
Rating: (not yet rated) |  Discuss |   Briefcase | 1,736 reads

You are a DTS programmer who wants to...

By Steve Jones 2003/11/21 | Category: dts
Rating: (not yet rated) |  Discuss |   Briefcase | 2,018 reads

You are a DTS programmer who wishes to...

By Steve Jones 2003/11/07 | Category: dts
Rating: (not yet rated) |  Discuss |   Briefcase | 1,394 reads

You are a DTS developer who would like...

By Steve Jones 2003/11/06 | Category: dts
Rating: (not yet rated) |  Discuss |   Briefcase | 1,740 reads
<< Newer    Items 61 to 80 of 123    Older >>
 
Tags
sql server 7 (76)    
administration (9)    
miscellaneous (9)    
programming (8)    
configuring (4)    
integration services (ssis) (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)    
64-bit (1)    
ado (1)    
advanced querying (1)    
backup / recovery (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 logging (1)    
handle (1)    
ini (1)    
openxml (1)    
package (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)