Re: Launch DTS Package using preferred resources
From: Darren Green (darren.green_at_reply-to-newsgroup-sqldts.com)
Date: 12/07/04
- Next message: Joern: "DTS Error - Server to Busy"
- Previous message: Darren Green: "Re: Help! Error when loading data from DBF table"
- In reply to: whornak: "Launch DTS Package using preferred resources"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 7 Dec 2004 13:32:47 +0000
In message <5677234F-BE5B-4B45-81F0-13C0560A04DF@microsoft.com>, whornak
<whornak@discussions.microsoft.com> writes
>>From my understanding, when a DTS Package is launched remotely the package is
> run using the resources of the remote machine. Is there a way to launch a
>DTS Package remotely and have it use the resources of the server?
>
>The problem I am having is that the server has email recipients defined in a
>different Profile Name then the remote machines. So when I run a package
>from the remote machine or process, after having the Profile Name set on the
>server, that email task fails.
You need to launch it on the server to get it to execute there. A couple
of methods are to call it via T-SQL (sp_OA* procedures or xp_cmdshell
and dtsrun), or use a SQL Server Agent job and start the job.
-- Darren Green (SQL Server MVP) DTS - http://www.sqldts.com PASS - the definitive, global community for SQL Server professionals http://www.sqlpass.org
- Next message: Joern: "DTS Error - Server to Busy"
- Previous message: Darren Green: "Re: Help! Error when loading data from DBF table"
- In reply to: whornak: "Launch DTS Package using preferred resources"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
