Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mauler05
Starting Member
17 Posts |
 Posted - 2007-11-24 : 14:31:49
|
| I have scheduled a SSIS package to run repeatedly by creating a scheduled SQL job that runs every minute . After every hour the packgae fails with the following errorDescription: System.OutOfMemoryException: Insufficient memory to continue the execution of the program. at Microsoft.SqlServer.Dts.Pipeline.Wrapper.IDTSCustomProperty90.get_Value() at Microsoft.SqlServer.Dts.Pipeline.ScriptComponentHost.CreateUserComponent() End ErroThe strange thing is that if i right click on SQL JOb and run it...it works fine.Did anyone encounter similar problem or know the solution of the above problem ?Thanks.... |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-11-24 : 21:15:39
|
| Sounds bug, did you apply any sql2k5 sp? Check sql2k5 sp readme files to find out if any fix for that issue. |
 |
|
|
|
|
|
Insufficient memory to continue the execution