Solved

How to run DTSRUN remotely from other Machine

Posted on 2008-10-10
2
388 Views
Last Modified: 2008-12-29
I have earlier on same server my application and MS SQL 2000 Server. Now I have switched my application to new server for load balancing.

On my Server where I have my application installed I also installed SQL 2005 for learning purpose but I still wish to use my MS SQL 2000 on old server.

Now in my application there are lot of .bat files which contain DTSRUN and OSQL which I want to run from my new Server but my database is on old Server. So I can not run these any more besides due to installation of SQL2005 I have dtstun and osql installed.

Can someone guide me how I can run DTSRUN and sql updates using osql when database is not on same server?

I can provide you script if desired.

Regards,

Nick
0
Comment
Question by:NickHoward
[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 Comments
 
LVL 9

Accepted Solution

by:
Sander Stad earned 500 total points
ID: 22685407
You can do this by executing the following code:
EXECUTE master.dbo.xp_cmdshell 'dtsrun /S (local) /U {uid} /P {password} /N {name dts package}'
Make sure you have enabled the cmdshell function in MS SQL 2005 Surface Area Configuration

 
0
 

Author Comment

by:NickHoward
ID: 22695575
Thanks. However when I connect to my SQL 2000 via SQL 2005 studio, my existing dts worked.
0

Featured Post

Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

Question has a verified solution.

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

International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

636 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