I have SQL SERVER 2005 Integration services installed on Windows Server 2003.......I am using VisualCron to run local, file based SSIS packages with local, file based SSIS config files that connect to another server hosting the SQL Server 2005 DB's......

When I run a CMD task in VC and issue the following....everything works fine.....

dtexec.exe /FILE "d:\SSIS Package Change Control\Model\OLB\DMU\DMUUpdate.dtsx" /conf "d:\SSIS Package Change Control\Model\OLB\DMU\MODEL DMUUpdate.dtsConfig"

When I attempt to run the Execute SSIS Package task...everything runs fine as well.......for about 24 hours.....then my packages begin to error out.....from what I can gather it's a memory issue with the VC service.......as soon as I restart the service...my Page File size drops and all is well....for about 24 hours.....SSIS logging indicates not enough system memory.....

We have changed our VC jobs back to using the CMD Task...but really like the Execute SSIS Package task......any ideas on why the VC service is not releasing system resources....?

Thanks

We will look through to see if we have missed anything regarding releasing resources and get back to you. Thank you for the report.

---

Please try version 5.0.7. we have gone through all ways of closing old objects. Hopefully it will work better. If not, we have found that there is also a bug in MSSQL 2005 SP2 and previous versions. Maybe this is fixed in SP3?

http://social.msdn.micro...-41bd-8f5c-9550e73986e6/ 

Anyway, please tell us about result with latest version 5.0.7.

---

Thanks.....

Interesting reading.....

I will upgrade when it is released...

Thanks

Both SP3 and 5.0.7. is released. But perhaps you were thinking about when 5.0.7. is on the ordinary download site? It is currently in the beta forum.

---

thanks...

we are evaluating SP3 for SQL and will probably apply it to our environments shortly....

I was referring to VC...any issue with insatalling the beta code...?

JT

Not that we are aware of, a lot of bugs has been fixed since the last version. The only thing you need to think of is that you just upgrade the old installation with the new (do not uninstall old first) and the settings will be transferred correctly.

---