submitted in error

Thanks Greg

I was thinking that myself but our server is at service pack 4 and we still have the problem.

Alan

Hi All

I have a log error for this now:

Step 'DTSStep_DTSExecutePackageTask_6' failed

Step Error Source: Microsoft Data Transformation Services (DTS) Package

Step Error Description:Not enough storage is available to process this command.

Not enough...

Hi everyone

I am still having a problem with this one and no answer in sight, has anybody got any other ideas Please?

Thanks

Alan Browne

Hi Mike

The code i am using is:

CREATE PROCEDURE spExecutePKGGlobalVariables(

 @Server varchar(255),

 @PkgName varchar(255),

 @ServerPWD varchar(255) = Null,

 @IntSecurity bit = 0,

 @PkgPWD varchar(255) = '',

 @GlobalV_1 varchar(511) = Null,

 @GlobalV_2 varchar(511) = Null,

 @GlobalV_3 varchar(511) = Null)

AS

SET...

I had the same error again this morning and this time I have traced it to failing on:

sp_OAMethod @oPKG, @Cmd, NULL

The DTS that runs all the commands is triggered at...

Hi, Yulia

No still have the same issue and seem to have to reboot server approx every 3 to 4 days.

I will try and get some more info together next time...

Hi Mike

Sorry taken so long to get back - had a family berivement.

There is nothing showing in any of the logs.

Someone has restarted server yesterday therefore todays worked.  The message...