Running DTS package on a different server...

Jagannathan Santhanam

We have 2 Windows 2000 Servers, Server2 and Server3. Server3 also
hosts a SQL Server 2000 Instance. Server2 DOES NOT host any SQL Server
2000 instances and is used as our Application Server. We are trying to
stop a "service" that is setup on Server2 by executing a DTS package
that resides in SQL Server on Server3. So far, we have had little luck
doing this. In other words, if you execute this package, it tries to
stop "service" on Server3 as opposed to stopping it on Server2.

Appreciate any help and feedback.

Thanks
Jagannathan Santhanam

Jul 20 '05 #1

Subscribe Post Reply

4233

Dan Guzman

If you have DTS installed on Server2 (i.e. SQL Server Client Utilities),
you can execute the DTSRUN command-line utility on Server2:

DTSRUN /S Server3 /E /N MyPackage

--
Hope this helps.

Dan Guzman
SQL Server MVP

-----------------------
SQL FAQ links (courtesy Neil Pike):

http://www.ntfaq.com/Articles/Index....partmentID=800
http://www.sqlserverfaq.com
http://www.mssqlserver.com/faq
-----------------------

"Jagannathan Santhanam" <ja*****@yahoo.com> wrote in message
news:60**************************@posting.google.c om...

We have 2 Windows 2000 Servers, Server2 and Server3. Server3 also
hosts a SQL Server 2000 Instance. Server2 DOES NOT host any SQL Server
2000 instances and is used as our Application Server. We are trying to
stop a "service" that is setup on Server2 by executing a DTS package
that resides in SQL Server on Server3. So far, we have had little luck
doing this. In other words, if you execute this package, it tries to
stop "service" on Server3 as opposed to stopping it on Server2.

Appreciate any help and feedback.

Thanks
Jagannathan Santhanam

Jul 20 '05 #2

Similar topics

How do I know that PHP is running

by: Frank Conte | last post by:

I'm having a problem running a simple printer friendly script written in PHP. I'm not sure whether the problem is with apache 1.3 or with the scripts. I updated apache's config file httpd.conf to...

PHP

Unspecified error when running Oracle 9i package via ASP

by: s_gemberling | last post by:

Here is the code that calls the Oracle package: Function b_GetRecords(sTableName, sRecordName) on error resume next dim cmd, objParameter Set conn =...

Oracle Database

Creating a DTS package

by: Jennifer | last post by:

I've created a DTS package and now I need to distribute it to different servers. I've been looking for a way to automatically/programatically create a DTS package, but have not found anything...

Microsoft SQL Server

DTS Package fails to find import file from c# app

by: Jason Smirnow | last post by:

I posted this to the SQL Server group but got no good responses, so I'm trying here... I have a DTS package I am kickig off from a C#.Net applcation that imports a tab delimited text file...

.NET Framework

Running DTS package from Access

by: kkrizl | last post by:

I have an Access database that has a few huge tables. It was taking about 20 minutes per table to import them from another application. I used the upsize wizard to put them in a SQL server...

Microsoft Access / VBA

Scheduling DTS Package using a stored procedure problem

by: KR | last post by:

The DTS package runs fine through Enterprise manager successfully. However, when scheduled through a job that runs the dts through the following code: DECLARE @findfile int Exec @findfile =...

Microsoft SQL Server

error when running the DTSRUN command

by: David Greenberg | last post by:

Hi We're using SqlServer 2000. I want to run a DTS using the DTSRUN command. The commmand is inside a ".bat" file which my application is running from an SQL client. No matter how I run it...

Microsoft SQL Server

Could not execute a package by a scheduled job

by: Jack Lee | last post by:

I try to set a job to run a DTS package, failed. My environment is SQL Server 2000 sp4 on windows Server 2003. There is a local window group called Dev_accnt including member SQLTesting who is...

Microsoft SQL Server

RE: Crystal Reports error code 1603 running deployment on a vista mach

by: =?Utf-8?B?Q2lhcmFuIE8nJ0Rvbm5lbGw=?= | last post by:

On reflection, you could possibly make the app a self extracting zip file which extracts the EXE and a settings file and then starts the app, then when you app closes, it can repack the settings...

C# / C Sharp

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Basic Javascript concepts

by: aa123db | last post by:

Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...

Javascript

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing