<div>
dtsrun /S Server2 /U UserName /P Password /N DTSPackageName
</div>


<div>
Let me make sure I explain more clearly:<br />
<br />
file.bat is on Server1<br />
SQL Server and DTS Package are on Server1<br />
file.bat is being run remotely from Server2<br />
<br />
Sorry if my initial post wasn't very clear.<br />
<br />
Thanks.
</div>


<div>
If server2 that runs the bat file can &quot;see&quot; server1 then probably you will not need any change.<br />
The bat file should be able to be run from any pc within the network that has the SQL Client Tools installed.
</div>


<div>
Both servers are behind the same firewall. I don't understand why mssql tools must be installed on server2 if that server is only being used to trigger the bat file (which runs the DTS job) on server1.
</div>


<div>
The server2 calls the bat file.<br />
But the bat file is executed locally on server2<br />
So the DTSRUN.exe must exists on server2 in order to be able to run.<br />
<br />
It's like having on server1 installed the Visual Studio, and you have created a bat file that opens the Visual Studio.<br />
When you call the bat from the server2 the code of the bat file is executed locally on server2 <br />
So the OS tries to locate the Visual studio on server2.<br />
<br />
You have to understand that the call of the BAT file is not a RPC (Remote Procedure Call) is actually a local call on the server2
</div>


<div>
I see... Server2 does not have mssql tools installed. So is there any other way to do what I'm trying to do?
</div>


<div>
Because the DTS needs to run as a result of another process.
</div>


<div>
<div class="content wysiwyg-content">
I have a .bat file on Server1. I need to execute the file from a remote server, let's say Server2. How would I modify this code, which currently works perfectly from the local server? I'm using MS SQL Server 2000 on Windows 2003 servers. Thanks.<br />

<pre><code class="code-1 nolinks" id="code-260555"><span>@echo off</span>
<span>REM</span>
<span>dtsrun /server1 /Uuserhere /Ppasswordhere /NDTSpackagehere</span>
</code></pre>
</div>
</div>


I have a .bat file on Server1. I need to execute the file from a remote server, let's say Server2. How would I modify this code, which currently works perfectly from the local server? I'm using MS SQL Server 2000 on Windows 2003 servers. Thanks.

Running a DTS package remotely

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.