Hi Everyone
I am running a scheduled stored procedure that executes a package, this is
run multiple times with different parameters.

This runs for a few days and then I get an error LoadFromSQLServer failed, I
get this message every time the stored procedure is run until I stop and
restart the SQL Server service. Once the Server has been restarted it again
works for a few days.

What may be the solution of such problem?

Thanks

Yuliaan

Hello Yuliaan,

If LoadFromSQLServer fails it almost sounds like the calling proc cannot
find the package on the server. maybe a network glitch I am not sure. What
i am interested in is why you are executing this using a proc?

There are other ways to do this that I would have chosen over the proc even
if i had some onfiguration to do inside the package.


Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com