Thanks. 

That gives me a direction I can try.  It works when there are two records per dp but if there is only one row it ignores the other rows...

I agree.  Especially if you're gone on vacation it takes forever to catch up.

Am I missing something or wouldn't the INSERT recommended get every type 50 record in the table SECC and not just the type 50 records returned by the stored procedure?

Should...

Sorry it took so long to repond to this, I'm a little behind going through the Community Updates.

It's been a few years but I migrated from Informix to SQL Server...

Another way to accomplish task is to use the copy tables option of dts and export the data to files nightly via a job.  Be sure to use the "delete...

One possibility for the jobs failing, if you have directed results to an output file and that output location is no longer valid or the permission on that location have...

Just a thought.  When you edit a maintenance plan and 'Attempt to repair any minor errors' is checked, the integrity checks are run in single user mode.  Check to see...

I'm not aware of any editors that check different formats of CRLF but that doesn't mean that there isn't any.

I like ftp even if you are not working with ascii...

I personally would try to use ftp instead of copying files to a floppy. Ascii files on the Solaris system would have just a line feed after each line...