DTS

SQLServerCentral Article

Automating DTS Execution

  • Article

Database Transformation Services (DTS) in SQL Server 200 was a breakthrough tool, really paving the way for a low-cost, easy to use, ETL tool. However, it was not a true robust programming environment and contains quite a few quirks that are apparent as you get into more detailed packages. New author Gus Carnu addresses one of those issues with a look at the ExecutePackage task.

2005-03-24

10,353 reads

SQLServerCentral Article

Coupling Outlook to SQL Server

  • Article

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.

5 (1)

2005-02-01

18,394 reads

SQLServerCentral Article

DTS: Copy Objects Task

  • Article

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.

2004-10-13

8,904 reads

SQLServerCentral Article

Comparison of Oracle Drivers

  • Article

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.

2004-07-21

16,566 reads

Blogs

Working with Neo4j Imports–I HATE CASE SENSITIVITY

By

I’ve been working to better understand graph databases and where they can be useful....

Daily Coping 8 Aug 2022

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Azure DevOps: Deploying Power BI reports with a parameterized gateway-based Data Source

By

(2022-Aug-08) You have developed your Power BI report, by connecting one or more sourcing datasets,...

Read the latest Blogs

Forums

WSFC DNS issue.

By snomadj

Morning all! I need to change the DNS entry for the IP address for...

How to use a Powershell script to track the network latency issue in AOAG

By Vincent92

Comments posted to this topic are about the item How to use a Powershell...

SSAS connection failures. Unable to read data from transport connection.

By ramana3327

Hi, Standalone default SSAS is installed. No issues connecting from SSMS on the server...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

DATETRUNC

See possible answers