SQLServerCentral.com Content tagged Programming, DTS

Executing a Package from Visual Basic

Fri, 18 Aug 2006 06:00:00 UT

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.

Copying DTS Packages To a Different Server

Fri, 05 May 2006 06:00:00 UT

How do you easily copy DTS packages from one server to another? DTS, BCP, T-SQL? Are there advantages to using one method over another? Andy did some research - read the article and see what works and what doesn't!

Leveraging XP Excel , XML, and OPENXML for Data Imports

Tue, 22 Nov 2005 07:00:00 UT

DTS is a fantastic ETL tool and it is often used to import Excel documents. However this can be a manual process in many cases in setting up the package. New author Sloan Holliday brings us a way that you can leverage Office XP's automation facilities and XML to import data into SQL Server.

Comparison of Oracle Drivers

Wed, 21 Jul 2004 06:00:00 UT

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.

Executing a Package from Visual Basic

Fri, 18 Aug 2006 06:00:00 UT

Make working with SQL a breeze
SQL Prompt 5 is the effortless way to write, edit, and explore SQL. It's packed with features such as code completion, script summaries, and SQL reformatting, that make working with SQL a breeze. Try it now.

Automate DTS Logging

Tue, 09 Sep 2003 06:00:00 UT

DTS logging is a pretty handy feature - if you've got it enabled. Got lots of packages and want to turn it on for all of them? Thats a lot of point and click using EM, but with the code Haidong has put together, it's a snap. Other possibilities to this code as well. After all, it uses a DTS package to modify other DTS packages.

‘Disturbing Development’
Grant Fritchey & the DBA Team present the latest installment of the Top 5 hard-earned lessons of a DBA – read it now

Trapping DTS errors with Transact-SQL

Tue, 27 May 2003 06:00:00 UT

Joe has written some articles for us, he also some interesting comment on his site - this article looks at trapping errors such as timeouts or divide by zero.

Case Study: Importing New Data Without Emptying Existing Tables

Thu, 09 Jan 2003 07:00:00 UT

The challenge for Robert Marda was to devise a way to keep the data available at all times while importing the new data, detect if a full or daily update was received and run appropriate data pumps, put in sufficient fail safes to ensure bad data would not get imported, and to make the process automatic including notification to pagers upon failure. Robert shows you how he did it here.

Copying DTS Packages To a Different Server

Fri, 05 May 2006 06:00:00 UT

Using FileSystemObject with DTS

Wed, 23 May 2001 06:00:00 UT

This article will show you how to use the FileSystemObject to determine the existence of a file inside DTS.