dtexec over the network

Hi All,

I'm trying to execute DTExec from a workstation and I got some help from a different group without luck maybe someone here can help me.

This is what I try so far.

1. My package run in command line from my sql box using dtexec with
parameters.
2. Set the package with DontSaveSensitive and import into IS under MSDB with
the same option setup.
3. Set package role to public.
4. Share DTS folder with everyone permission just for testing.
5. Execute the package from a workstation using
//sqlServerbox/DTS/BINN/dtexec /dts "msdb/mypackage" /SER "MySQLServer" /set
\package.variables[myvariable].Value;"myvalue1,myvalue2"
(myvariable is string and I can pass multiple values separate by commas)
6. Still getting error:
Error: 2007-02-09 10:31:34.31
Code: 0xC0010018
Source: Execute DTS 2000 Package Task
Description: Error loading a task. The contact information for the task
is "E
xecute DTS 2000 Package Task;Microsoft Corporation; Microsoft SQL Server v9;
? 2
004 Microsoft Corporation; All Rights
Reserved;http://www.microsoft.com/sql/supp
ort/default.asp;1". This happens when loading a task fails.
End Error

Anyone has any ideas?

Any help will be appreciate it. Tks in advance...

Rgds

Johnny

You can't just run DTEXEC without installing it. You need to install SSIS locally.|||

That is not true... I can run a package from a workstation without installing IS, I share the dts folder and it's working...

Anybody else try this?

Tks

JFB

|||

I don't understand. You start a thread by asking why it does not work. Now you claim it is working.

Do you have Client Components installed on the workstation? If you do, you can simply run your own DTEXEC from Program Files instead of running it from network share.

|||Tks for you reply. If you read my first post with careful you will see that the package run without installing IS on the workstation. I have and error and thats my problem, I can't figure out the error ... I believe is a security issue but I don't know how to fix this.
I will keep trying to get more info about it or if anybody try this or know how to solve this problem.
Rgds

JFB|||

DTSuser wrote:

Tks for you reply. If you read my first post with careful you will see that the package run without installing IS on the workstation. I have and error and thats my problem, I can't figure out the error ... I believe is a security issue but I don't know how to fix this.
I will keep trying to get more info about it or if anybody try this or know how to solve this problem.
Rgds

JFB

Right, but I think what Michael is saying is that even though dtexec executes, you are still missing libraries and such that will be required to execute that. You aren't executing dtexec on the remote box, you are executing a remote copy of dtexec on your box. Hence, you will need to install the SSIS client tools.