Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
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,318 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,877 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,729 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,510 reads

You are a DTS programmer who wishes to...

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

You are creating a DTS package in SQL...

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

You are a DTS programmer who is trying...

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

You are a DTS programmer that is trying...

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

What is the difference between user and owner...

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

You are a DTS programmer who has created...

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

You create a SQL Server 2000 Service Pack...

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

You need to create a DTSRUN command to...

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

You are a DTS programmer who wants to...

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

You are a DTS programmer who wishes to...

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

You are a DTS developer who would like...

By Steve Jones 2003/11/06 | Category: dts
Rating: (not yet rated) |  Discuss |   Briefcase | 1,750 reads
<< Newer    Items 61 to 80 of 123    Older >>
 
Tags
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)    
ssis package (1)    
system development life cycle (1)    
updategrams (1)    
vbscript (1)    
xml (1)    
xsl (1)