I have a package saved in SQL server on my machine. It is one source dataflow
component(select..) and one datareader destination.
in a commandprompt I can execute with dtexec, everything goes OK.
When I try to run in VB (same machine) with dtsclient.dtsconnection
/dtscommand as
found in examples for retrieving from datareader, I get message
"Could not obtain a DataReader object from the specified data flow component."
I am logged in as a sysadmin and run with integrated security in the machine.

From a Windows application on an client machine (not an SQL server client) I
want to start a package execution on a remote server (SQL server hotel) and
get the result back in a datareader.
Is this the correct way to do so?
--
r-m

Solved the problem, of some reason DelayValidation was set to True, when I
changed to false, everything worked OK.
Would still like an answer to my last question, if you can use dtsclient
assembly to call a package stored in a remote SQL server. How do you specify
the connection to
that SQL server then?
--
r-m


"rosie" wrote: