Re: LoadFromSQLServer error

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Allan Mitchell <allan@xxxxxxxxxxxxxxxxxx>
Date: Thu, 25 May 2006 02:10:02 -0700

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

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

Prev by Date: Re: Deleting the SSIS package when it is running
Next by Date: Re: DTS Connection Server Name
Previous by thread: Re: SSIS An error occurred while attempting to perform a type cast
Next by thread: Re: DTS Connection Server Name
Index(es):
- Date
- Thread

Relevant Pages

TSLSA-2007-0007 - multi
... Affected versions: Trustix Secure Linux 2.2 ... The mod_php module enables the Apache web server to ... The postgresql package includes the client programs and libraries ... SECURITY Fix: Fetchmail does not properly enforce TLS and may ...
(Bugtraq)
Re: remotely call a DTS
... Allan Mitchell wrote: ... Denied on something inside the package. ... This worked when I was logged into the server and ran it from my ... but the DTS blows up. ...
(microsoft.public.sqlserver.dts)
Re: sunmanagers Digest, Vol 34, Issue 14
... Christopher sent me a link to ftp.cs.tu-berlin.de that has all patches sun ... Subject: SUMMARY: Setting up mail on a Solaris Server ... however I seem to be having issues finding a binary package. ... Problems while installing 108528-29 for Sol8 machine ...
(SunManagers)
Re: DTS Environment Control
... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.SQLDTS.com - The site for all your DTS needs. ... When run from the production environment, the production server is accessed and when run from the test environment, the test server is accessed. ... For simple packages it's not too big of deal - but for more complete ones - you can spend an hour carefully changing all your connections. ... I had one solution where we would add an ActiveX script task as the very first step, that would determine what SERVER the package was executing from - and based on that would dynamically change all the connections by looking up the package name and server from a DB. ...
(microsoft.public.sqlserver.dts)
is yum working? unable to update a system
... # yum update ... Server: Dag RPM Repository for Fedora Core ... .Package mplayer-mencoder needs libxvidcore.so.2, this is not ...
(Fedora)