DTS

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,301 reads

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,119 reads

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,721 reads

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,000 reads

Blogs

SSIS Scaleout: Cannot open certificate store on the machine

By

When attempting to connect a worker node to the current Master node of a...

Adding a License to GitHub

By

I’ve rarely thought about licensing my code, but it’s something to be aware of...

Weekly reading #29

By

The Data Breach Game: The 9 Worst IT Security Practices Joey D’Antoni shows bad...

Read the latest Blogs

Forums

Automatic decimal round off

By VSSGeorge

Automatic decimal round off is happening for a column having datatype Decimal (6,2). I...

unable to restore db

By vsamantha35

Hi All, Unable to restore/refresh a database. I was able to kill the sessions...

cpu and duration of SQL profiler and cpu_time and duration of Extended event

By 892717952

Sorry for troubling you  for the following questions, thanks! 1. when I use SQL...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers