Hi, I am created a Stored Procedure and it will return XML result set. I am calling this storedprocedure in SSIS package ( using the execute SQL task) and writing the result of the StoredProcedure in a file ( by using the script task ) . Now i configure the SP to return only 4 rows, the SSIS package is getting executed and a xml file will be written in a folder. If the SP is configured to return all the rows, then there is Insufficient memory to continue the execution of the program error. Detail error: "Insufficient memory to continue the execution of the program.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly." while executing the Execute SQL task. Execute SQL task : Result Set = XML Can anyone please let me know how to resolve this error and why there is an error when all the rows are returned ( the xml file with all rows is returned from the Stored Procedure ). -Prasad

Hi Prasad, Please try the suggestions in the following thread - http://social.msdn.microsoft.com/Forums/en/sqlintegrationservices/thread/9f830a92-f989-4794-86a4-3d78e1cf2ec5 Hope this helps.Shahfaisal Muhammed http://shahfaisalmuhammed.blogspot.com

Prasad, just try running the package elsewhere, I think your machine just does not have enough processing power, the remedy is in adding more RAM.Arthur My Blog

even if i run it with machine having 16GB, it is not working.-Prasad

See if this Connect item apples to you: http://connect.microsoft.com/SQLServer/feedback/details/507494/alter-index-rebuild-fails-with-severe-errorArthur My Blog

Hi Prasad, Please restart the MSSQLSERVER service and then check if the package can run. If in this case, the problem is related to SQL Server database rather than SSIS. Please check how much maximum memory you have configured the SQL Server service to consume. I suggest you using DBCC MEMORYSTATUS to Monitor SQL Server Memory Usage and find the root cause finally, details about it, please see: http://support.microsoft.com/kb/271624 For more information about Server Memory, please see: http://msdn.microsoft.com/en-us/library/ms178067(v=sql.100).aspx Please feel free to ask if you have any question. Thanks, Eileen TechNet Subscriber Support If you are TechNet Subscription user and have any feedback on our support quality, please send your feedback here. Please remember to mark the replies as answers if they help and unmark them if they provide no help. This can be beneficial to other community members reading the thread.