hi,
I am trying to run a stored procedure to execute a DTS
Package as exactly explained in the following URL:
http://www.databasejournal.com/featu.../article.php/1
459181

but, I am always getting problem with

*** LoadFromSQLServer failed
HRESULT: 0x80030003
sp_OAGetErrorInfo failed

Any Ideas?

I saved a package on a client system and running the
stored procedure from that client system. Is this cause
of the problem?

thanks

In message <188cc01c420a1$66379a40$a601280a (AT) phx (DOT) gbl>, sreenath
<anonymous (AT) discussions (DOT) microsoft.com> writes
The stored procedure (and indeed all T-SQL code) will always run on the
SQL Server machine. If the package is stored elsewhere then that may be
the problem, since the SQL Server security context may not have network
or security permissions to load the package from the client. Try saving
the package to the Local Packages stored on the same server you are
running the T-SQL against. Then set the server name to "(local)" and
check the package name is correct for LoadFromSQLServer call.

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org

hi Darren,
Could you post y our message again. I am getting messgae
unavailable.

In message <1bdc601c4215a$347df620$a401280a (AT) phx (DOT) gbl>, sreenath
<anonymous (AT) discussions (DOT) microsoft.com> writes
SQL Server machine. If the package is stored elsewhere then that may be
the problem, since the SQL Server security context may not have network
or security permissions to load the package from the client. Try saving
the package to the Local Packages stored on the same server you are
running the T-SQL against. Then set the server name to "(local)" and
check the package name is correct for LoadFromSQLServer call.
--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org