Great!  Thanks for the info!

Thank you for taking the time to provide the information.  Unfortunately the power in the 'ROLAP Dimension' escapes me. 

I want Real-Time Cubes where I don't have...

We get no error ... just suspect databases.  We can backup a database from one system and restore to another on another server with no problem.  Our ODBC is ok...

The job ran for a month with no issue then suddently started to hang and the batch size didn't change : /.    I'll try pulling 1 day rather than 5...

If we continually load 2.6 million rows what might be a good set of settings for the DTS Package?

I've got it running but it is slow.    While ops is running tape backups of pervasive I get noting out of it but a 94 lock message.  Any idea why?  ...

Pervasive is an SQL database accessed via ODBC Connections.

How long is it hanging?  Hours ... eventualy starts ... then hangs again after 1.2 million records of 5 million expected...

I dared to move on giving the interface an SQL file with a Select statment in it (Complex with CASES and Joins) and table names (Tables referenced in the SQl...

When I look at the process initially is shows sleeping and:

select collationname(0x0904D00034)

why is it looking for collationname?

The package is copying 2 fields from an ODBC data source.

My systems administrator cleared and saved the event logs.   Since then the problem has not reoccured.

Is there a DTS Package setup option that may have caused logs to fillup?

By The...

Thanks.   I can tell you we are raid 5 but that is it.  I'll check the cache.  Thanks Again

Questions 1-3 really were a bit off the mark.  Question/stmt 4 hit the mark.  It is disk corruption where SQL hits EMC.

1. Where is your SQL Server installed? Enterprise Manager...

I found the PRINT statement.  Why would that cause the error I received?   I took the print out and things run fine now.

Does it do this if you run it interactively? Yes.

Can you double click the failed item and get an error?  Yes (Error was in the original posting)

The only other...