• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 626
  • Last Modified:

How do I Run a DOS .bat file from a dts package?

How do I Run a DOS .bat file from a dts package?
Using SQL Server 2K - Win2K - XPP
0
Justin_Case_77
Asked:
Justin_Case_77
  • 3
  • 2
1 Solution
 
MarcRosenbergCommented:
Within the DTS Job... Choose Task... (4) Execute Process Task:Then specify the location of the bat file and any parameters, timeouts etc.

Good Luck.. Hope this Helps

Marc
0
 
arbertCommented:
You can also use an Execute SQL Task with master..XP_CMDSHELL 'c:\yourbat.bat'

You could also use the ActiveX task to do it....What exactly do you need to do within your job flow?
0
 
Justin_Case_77Author Commented:
Yes, Thank you.  I was using an 'Execute Process Task' to execute the bat file.  I had an error in the bat file.

My recommendation to future readers of this thread is to use absolute paths to executables.
0
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 
arbertCommented:
So you selected an answer that you found a solution to on your own?
0
 
Justin_Case_77Author Commented:
My first question on this forum and I should have debugged it myself first.  Feeling a bit humbled right now.  Going to read up on this whole point system thing. Don't really understand it yet.  Thanks to all that tried to help.
0
 
arbertCommented:
If you solve a problem yourself, you can request to close the question and refund your points...
0

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now