SQLServerCentral.com Content tagged DTS, Visual Basic 6

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!

Executing a Package from Visual Basic

Fri, 18 Aug 2006 06:00:00 UT

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.

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