I am calling a DTS from a stored proc and get this error message.
ERROR : LOCATION = LoadFromSQLServer SOURCE = Microsoft Data Transformation Services (DTS) Package DESCRIPTION = Not enough storage is available to process this command.

Anyone seen this before. There is plenty of space and the DTS will run outside of the stored proc.