How would your suggestion work with the updated table structure I posted?

Also, the table has ~6M rows in it, so I can't really input the data the way you showed...

Seems like this isn't pulling back records as intended. Every phone number came back showing '3' calls.

I received a minor change to the requirements and have tried to simplify this as a result.

I created a new table that only has 3 columns in it:

PHONE_NBR (self-explanatory)

CALL_DATE (date...

Yeah, I found out about the lock - the hard way.

Using SSIS, how can I check the value in one column in table 'x' and then based on the value,...

Yeah, I've created tables that way before, but I'm currently inserting the records into an existing table.

Would a create table statement be markedly faster than an insert into?

No, not a text file. I'm hitting an Oracle back-end db. I'm using the openquery because it seems to be the only way I can get the data extraction to...

There is not a USE statement at the beginning of the query. I prefaced all of my schemas/tables with the appropriate db information.

The job history simply shows it was completed...

Let me clarify...I have jobs that are executing SSIS packages AND jobs that are just embedded sql code...BOTH types are working fine. I realize the SSIS scheduled jobs are different...

I don't know that it is a permissions issue. I have other jobs hitting the same back-end source and they're not having a problem.

All the query does is go out...

Yes it would, but I'm also wanting to add some kind of notification that the data has not been updated in the source table, and have the query try again...