?
Solved

How do I execute a DTS package using T-SQL in Query Analyzer?

Posted on 2002-07-08
3
Medium Priority
?
175 Views
Last Modified: 2008-02-20
How do I execute a DTS package using T-SQL? I'm gonna use it to call the package from an application using OLE-DB/ODBC.
0
Comment
Question by:yurrea
[X]
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
  • 2
3 Comments
 
LVL 143

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 400 total points
ID: 7139859
You have 2 options:
* create a job that runs the package, and to start the job use this sample:
exec msdb..sp_start_job @job_name='StartDTS_yourdts'

* run the DTSRUN command line tool (sample):
exec xp_cmdshell 'DTSRUN /N yourdts'

CHeers
0
 
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 7139860
FYI, i do prefer the first option...
0
 

Author Comment

by:yurrea
ID: 7139918
Hey thanks angelIII! That was a great help. :)
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Suggested Courses

770 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