Re: Run DTS 2000 Package on a remote server

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: EMartinez <emartinez.pr1@xxxxxxxxx>
Date: Fri, 07 Sep 2007 21:11:14 -0700

On Sep 5, 7:44 pm, Coop <C...@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

I have a SSIS package on a SQL 2005 server. From within the SSIS package,
how do I trigger a DTS package on a remote SQL 2000 server to run on that
remote server, as oppossed to importing the 2000 package and executing it
locally on the 2005 server?

Thanks.

I'm sure that there are other ways of doing it, but you could try
using a script task that accesses a stored procedure on the other
server that uses xp_cmdshell to execute DTSRun locally on that SQL
Server. Hope this helps.

Regards,

Enrique Martinez
Sr. Software Consultant

.

Prev by Date: Re: Importing Excel files with columns > 255 chars
Next by Date: Re: How to import if different lines hold different sorts of data?
Previous by thread: Re: Importing Excel files with columns > 255 chars
Next by thread: Re: How to import if different lines hold different sorts of data?
Index(es):
- Date
- Thread

Relevant Pages

Re: Error running DTS package on a schedule (only!)
... I use Remote Desktop to access the server where the DTS package was ... > Right Click on the SQL Server Agent icon in EM and choose properties. ... > page here will tell you the account. ...
(microsoft.public.sqlserver.dts)
Re: Job Error. Need help ASAP.
... When you run a DTS package through EM you are ... If it can't connect to the server on the DMZ then have your ... connectivity by opening a dos window and telnetting to port 1433 on the DMZ ... This will tell you if the port is open. ...
(microsoft.public.sqlserver.security)
"Failed" Job runs DTS package
... pulls new data from a database on a different server. ... Now the DTS Package completes, but the Job says it failed. ... DTSStep_DTSExecuteSQLTask_2 DTSRun OnFinish: ... DTSStep_DTSExecuteSQLTask_2 DTSRun OnStart: ...
(microsoft.public.sqlserver.dts)
Re: DTS Tasks running in job random failure
... > then uninstalled (created a unforseen problem on the server). ... > a lookup, which I'd like to follow Microsoft's advice for a workaround to ... > Job now running is one Job executing one DTS Package that executes 6 DTS ...
(microsoft.public.sqlserver.dts)
Re: Scheduled DTS Package
... >The datapump tasks are copying data from an Oracle DB server to my SQL ... Make sure the driver is correctly installed on the server and is ... available for the SQL Server Agent service account. ... How to Run a DTS Package as a Scheduled Job ...
(microsoft.public.sqlserver.dts)