Improve company productivity with a Business Account.Sign Up

x
?
Solved

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

Posted on 2002-07-08
3
Medium Priority
?
187 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
  • 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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

When trying to connect from SSMS v17.x to a SQL Server Integration Services 2016 instance or previous version, you get the error “Connecting to the Integration Services service on the computer failed with the following error: 'The specified service …
One of the most important things in an application is the query performance. This article intends to give you good tips to improve the performance of your queries.
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

579 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