Hey Steve,

Thanx, I thought maybe there was a built-in feature I didn't know of...

Thanx Ben!

This certain job has one step...

Yeah, To the Windows Application Event Log....Through the job's properties...

Thank you Allen!

My database table are hardly this big...a few 1000's maybe....maybe even 200,000 but not near the 1M range.

But I'll keep your advice in mind for sure.

Thanks a lot Remi!

This helps a lot! I will definately go over everything and try it out.

Thanks Remi,

I will definately try this. And I would like your help on the Update and Insert...

Also I was wondering, what do you think is the best way to have...

Don't be sorry!!

Antares686,

Thanks a million! it works in the blink of an eye now! (with the CASE op) ...

Thanx to everyone else who also replied!!

There must be a better (more efficient) way to do this. My op simply counts the number of records that are NOT IN the specified dates.

There are only about...

Antares686,

I see what you mean, I've tried that already before (when I first encountered the OR problem ) but this causes me to loose records that, for instance, have an...

I've tried Using the OR operator beofre (that's actually the first thing I did, something like what Antares686 posted..) but appearantly SQL server doesn't group that statement like I wanted ...

I forgot to config the ODBC DSN on the server.....what a goof..

Thanx for all your help mike.

Yes, I had originally tested the package on a client...sorry for not mentioning that.

Last night we installed the latest update for the Visual FoxPro ODBC Driver on the server (the...

Hey Everyone,

I have a new problem now. When I run the package that imports the dBase table on the server (Windows 2000) I get the following error message:

Error...