Hello,

I have a stored procedure (which uses the sp's sp_OACreate,
sp_OAMethod, etc.) that should execute a DTS-package on the server.
This DTS-packages exports data from SQL Server database to an existing
Access 97 database.

When I run the DTS on the server, everything works just fine and my
Access 97 db is filled with data from SQLServer. However, when I
execute the SP that should execute the DTS from a SQL Query Analyzer I
get the following error:

Not enough storage is available to process this command.

Even when I do this in a SQL Query Analyzer on the server.
SQL Server SP 3 is installed on the server, and there's plenty of
memory available.

Can someone tell me what I'm doing wrong?

Pieternel,

As you guessed the error description is bogus. Under different circumstances
we have the same error, reported it to MS and they declared it as a bug.

Ilya

<Pieternel.Fieret (AT) gmail (DOT) com> wrote

Thanks Ilya. Did they give you any solution?

Pieternel,

We've found a workaround which in our case was getting rid of lookups in
transformation tasks.

Ilya

"Pieternel Fieret" <Pieternel.Fieret (AT) gmail (DOT) com> wrote