Re: DTS Tasks running in job random failure

Helge:

Thanks for the reply. We are running under Win2k3 with SP1 installed and
then uninstalled (created a unforseen problem on the server). Job ran fine
for about a week and then started giving errors. Yes, this one uses a
lookup, which I'd like to follow Microsoft's advice for a workaround to "not
use lookup queries in DTS packages" but I'd like to see them do what I am
without the use of one. We have got it working again by rebooting the
server. The reason we started this job was because a previous one began
failing right at the end with Microsoft .NET crashing on cleanup.
Everything ran fine, but it kept reporting a failure because of cleanup
problems. Rebooting the server fixed that one so we have moved back to
using it instead of this one. And, yes, it is using a lookup without
problems. Difference between the two jobs is a follows:

Job in question is one Job with 6 steps. Each step executes a separate DTS
package.
Job now running is one Job executing one DTS Package that executes 6 DTS
packages.

Sounds like Microsoft doesn't even understand what fixes the issue. Lookups
work fine as long as not executed directly from a job. Must call the lookup
package from another package for it to work. We would never have gotten
this error has .NET not started messing up.

Scott

"Helge C. Rutz" <news050424@xxxxxxxxxxxxxx> wrote in message
news:3dp1reF6pcaf7U1@xxxxxxxxxxxxxxxxx
> Hi Scott
>
> "Wm. Scott Miller" <Scott.Miller@xxxxxxxxxxxxxxxxxxxxxxxxx> schrieb im
> Newsbeitrag news:%2361SU2yTFHA.3636@xxxxxxxxxxxxxxxxxxxxxxx
>> Dear All:
>
>> The error we keep getting in the package logs is:
>> Step Error Source: Microsoft Data Transformation Services (DTS) Package
>> Step Error Description:Not enough storage is available to complete this
>> operation.
>> (Microsoft Data Transformation Services (DTS) Package (8007000e): Not
>> enough storage is available to complete this operation.
>> ) (Microsoft Data Transformation Services (DTS) Data Pump (8007000e): Not
>> enough storage is available to complete this operation.
>
> do you use lookups in the transform? Then this would be a known bug in SQL
> Server.
> If so, you can order a hotfix to solve the problem.
> http://support.microsoft.com/default.aspx?scid=kb;en-us;889170
> I noticed this error only on W2k3 Servers with SP1 installed, so far.
> Which system do you use?
>
> Helge
>


.

Relevant Pages

  • 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: JOB fails immediately
    ... We have a new server outside of our LAN and I have the exact same problem. ... > I created a dts package that when manually run, ... > Help file: sqldts80.hlp ...
    (microsoft.public.sqlserver.dts)
  • Re: DTS in VB: system hanging after SP4 installed
    ... SP4 of what? ... I am not sure about the setup of the package though? ... You have DTS installed where? ... You pick the package up from that server? ...
    (microsoft.public.sqlserver.dts)
  • RE: DTS fails to import data when called from VB6
    ... DTS package within SQL Server it is saved as the current user. ...
    (microsoft.public.sqlserver.dts)
  • Re: Tree Structure & Triggers.
    ... > The table is really only going to be used as a lookup table for a DTS ... > package that's being used on a weekly basis, ...
    (microsoft.public.sqlserver.programming)