Call SQL DTS package from Delphi 6

Posted on 2003-03-07
Medium Priority
Last Modified: 2013-11-30
How can I incorporate a call an MS SQL DTS local package from Delphi 6 at design time?
Question by:gaily
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
LVL 18

Expert Comment

ID: 8090321
At design time? The dts package will only be loaded and executed at run time.

I don't know delphi but you can run the dts package from a stored proc call

sp_oacreate Load DTS

I wouldn't advise to do this but it shows how to use the object model to run the package.

Author Comment

ID: 8090412
I'm a somewhat technical user who is trying to rewrite some DOS Paradox applications using Delphi which is a RAD Pascal code generator.  I don't know VB, nor Pascal very well for that matter,  and was hoping there was some TObject thing that I haven't found yet that would let me execute DTS at run time.  Net/net:  Your answer was beyond my limited knowledge, but thank you...
Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.


Expert Comment

ID: 9276063
This old question needs to be finalized -- accept an answer, split points, or get a refund.  For information on your options, please click here-> http:/help/closing.jsp#1 
Post your closing recommendations!  No comment means you don't care.

Author Comment

ID: 9279997
It's dead.  I answered my own question, see comment from gaily above. Thanks.
LVL 12

Expert Comment

ID: 11042408
No comment has been added to this question in more than 21 days, so it is now classified as abandoned.

I will leave the following recommendation for this question in the Cleanup topic area:
    PAQ with points refunded

Any objections should be posted here in the next 4 days. After that time, the question will be closed.

EE Cleanup Volunteer

Accepted Solution

Computer101 earned 0 total points
ID: 11135961
PAQed, with points refunded (250)

E-E Admin

Featured Post

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Viewers will learn how the fundamental information of how to create a table.
Suggested Courses

800 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question