Hi All,

We are experiencing some weird problems. The SSIS package we made is
stopping after "randomly" 1 to 3 hrs. Doesn't matter if we run it from
the Designer ( in Debug ), Commandline or Server Management Studio. We
don't get any error message,it just stops like it is finished the job
completely.

Our package is composed of One big loop, which grabs a one day of
bussiness data. This data is then inserted or updating an other table (
no activeX transformation ). Just straight SQL transformation. About
80.000 rows are updated or inserted for each day of bussiness data.
And each loop takes approx. 15 mins

The package stops in the middle of the loop! On different points in the
loop.

If the package is stopped, and we restore a backup. And run the package
again, it doesn't stop at the same point.

No error message is display, or written in the eventlog or SQL Server
log.

My questions:
- How do I debug a problem like this?
- Anyone had any similar problems?
- Any suggestions on solving this problem?

Some system details:
- MS 2003 R2 ( latest windows updates installed )
- MS SQL 2005 SP1
- Xeon 2,8ghz / 2Gb ram / 200 Gb free HD space
- Source and destination DB are on the same server

Thx.
Jerry Verhoef