SQLServerCentral: Content tagged dts

Click here to monitor SSC

<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>

SQLServerCentral is supported by Red Gate Software Ltd.

Log in :: Register :: Not logged in

<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>

Content with tag dts

<< Previous 20 Items 61 to 80 of 122 Next 20 >>

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:

|

Briefcase | 15,807 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:

|

Briefcase | 9,703 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:

|

Briefcase | 10,454 reads

You are a DTS programmer who wishes to...

By Steve Jones 2004/05/05 | Category: dts

Rating: (not yet rated) |

Briefcase | 1,729 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:

|

Briefcase | 39,661 reads

You are creating a DTS package in SQL...

By Steve Jones 2004/04/23 | Category: dts

Rating: (not yet rated) |

Briefcase | 1,742 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:

|

Briefcase | 9,760 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:

|

Briefcase | 47,517 reads

You are a DTS programmer who is trying...

By Steve Jones 2004/03/10 | Category: dts

Rating: (not yet rated) |

Briefcase | 1,620 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:

|

Briefcase | 10,856 reads

You are a DTS programmer that is trying...

By Steve Jones 2004/03/08 | Category: dts

Rating: (not yet rated) |

Briefcase | 2,275 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:

|

Briefcase | 24,975 reads

What is the difference between user and owner...

By Steve Jones 2004/01/23 | Category: dts

Rating: (not yet rated) |

Briefcase | 1,054 reads

You are a DTS programmer who has created...

By Steve Jones 2004/01/07 | Category: dts

Rating: (not yet rated) |

Briefcase | 1,413 reads

You create a SQL Server 2000 Service Pack...

By Steve Jones 2003/12/18 | Category: dts

Rating: (not yet rated) |

Briefcase | 1,933 reads

You need to create a DTSRUN command to...

By Steve Jones 2003/12/08 | Category: dts

Rating: (not yet rated) |

Briefcase | 1,723 reads

You are a DTS programmer who wants to...

By Steve Jones 2003/11/21 | Category: dts

Rating: (not yet rated) |

Briefcase | 2,006 reads

You are a DTS programmer who wishes to...

By Steve Jones 2003/11/07 | Category: dts

Rating: (not yet rated) |

Briefcase | 1,381 reads

You are a DTS developer who would like...

By Steve Jones 2003/11/06 | Category: dts

Rating: (not yet rated) |

Briefcase | 1,729 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:

|

Briefcase | 8,875 reads

<< Previous 20 Items 61 to 80 of 122 Next 20 >>